select from db
| From: | BigMark | Date: | Fri, 04 Jun 2004 22:20:40 +0000 |
| Subject: | select from db | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-187596@lists.php.net to get a copy of this message | ||
Hi i have a football tipping database and i need to extract certain records
from a users 'selections' table
table name 'Selections'
(rows) Round Game Name Winner Points
data eg 1 1 mark Hawthorn 4
(if team is a winner then 4 points added)
1 2 mark Geelong 0
What i want to do is show all the above rows of a particular user and round,
ie: all of user 'mark' round 1 details which includes games 1-8, the team
names he picked, and the points for a win.
p.s. is there a way of totaling the points as well
mark