Help With Coding
| From: | dallas22 at airmail dot net | Date: | Sun, 13 Aug 2000 14:26:49 +0000 |
| Subject: | Help With Coding | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-11517@lists.php.net to get a copy of this message | ||
Hi
I have two tables, Results and Assignments
Results has the following fields
Week (With selections of Week 1, Week 2, Week 3, Week 4)
Winner
Loser
Wins
Losses
Assignments has the following fields
Week (With selections of Week 1, Week 2, Week 3, Week 4)
Player 1
Player 2
I have a script to display ALL assignments
I have a script to display all results
What I'd like is a script that shows who has not posted match results for
assigned matches. (Backgammon League)I'd need a script to display
Assignments that do not have a Results posted for them in the Results table.
Example
Assignment Table
Week Player 1 Player 2
Week 1 Tom Jerry
Week 2 Ed Tim
Week 3 Josh Salvador
Week 1 Sue Nancy
Results Table
Week Winner Loser Wins Losses
Week 1 Sue Nancy 2 1
Week 2 Ed Tim 3 0
The Script I would like would then show unplayed matches
Week Player 1 Player 2
Week 3 Josh Salvadaor
Week 1 Tom Jerry
Thanks for any help on this