I'm using radio buttons to select the player status. So here's what I was thinking would work. I have a separate grouping for each player. My HTML form looks something like this
Player # | Present | Absent
----------+--------------+-----------
3 | o o
4 | o o
6 | o o
7 | o o
So in the first row, for player # 3, the radio button code would be like this:
<input type = radio name = status1 value = present>
<input type = radio name = status1 value = absent>
the second like this:
<input type = radio name = status2 value = present>
<input type = radio name = status2 value = absent>
And so on...I can see this is going to turn into a long explanation. Bear with me. My thinking was that on the next page I could store the player numbers in an array. Then I could access the $POST array, grab the first value in the $POST array (either present or absent) and send that to the database. The number of items in the $POST array would match the number of players in the player array so I could just loop through both arrays. I'm amazed if you're still with me at this point.
for ($i = 0; $i < sizeof($_POST array); $i++)
{
UPDATE $teamname SET $game_date = '$_POST array first value' WHERE player_num = 'player array first value';
}
In theory, this method should work. But it doesn't. I've described the problems that I've run into in a previous thread here:
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10233860
I've probably successfully scared off any help at this point but if anyone has any thoughts I'd love to hear them. Thanks
