Help With Coding

From: 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

« previous php.general (#11517) next »