Do you have a question? Post it now! No Registration Necessary. Now with pictures!
May 11, 2006, 1:12 pm
rate this thread
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
Thanks so much...
Re: fishing tournament results
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
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum