I have a list of games/matches where I want my users to choose a winner.
They make their choices via Select Boxes. Each week the winner will choose many games.
When the user clicks the Submit button, I need the following to happen:
Each game that the user picks is entered into the PICKS table:
The UserID and WeekID are already known from the users login.
Each checkbox needs to add GameID and CHOICE to the PICKS table.
Here is the sample page:
So in the first Select Box, User #300, for Week #1, selects "Utah" in GameID #4.
The 2 things I'm having trouble with are:
1. Passing BOTH the GameID and the CHOICE from the select box.
2. Making the array so it inserts 12 records to the DB and not just 1.
I'm sure others have done something like this before, but I'm just unsure of how to setup the <FORM> and the SELECT Array.
If Possible, I'd like the form to UPDATE as well, so if a user comes back later, they can CHANGE their pick.
Thanks in advance,