fishing tournament results

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Well, I've got 2 tables I'm wanting to pull date from sorted by most points

Here's the structure...

tnumbers table (holds all tournament points: tid, mid, points
rollcall table: mid, here

I would like to list all tournament results in a row, along with the total
amount of meeting points (here*10), with the total of all tournaments plus
the meeting points. I would like these listed all in 1 row per angler...

Angler                Jan    Feb    Mar    Apr    May   Meetings    Total
Kevin VanDam   60       37       45      32                       50
Ish Monroe         50       40       38      42                       50
etc, etc...

Thanks so much...

Re: fishing tournament results

Bryan wrote:
Quoted text here. Click to load it

This isn't enough information to answer the question.  We have no idea
what any of these columns contains, and it's hard to infer from the
names.  For instance, which column contains the name of the angler?  Are
any of these columns dates?  There is no way for readers to guess.

When asking questions like this, please post the results of SHOW CREATE
TABLE for each of these tables, and describe the meaning of the columns.
  Even better would be a few rows of sample data.

Anyway, I am guessing that the following article may help you do what
you want:

Bill K.

Site Timeline