Update Multiple Rows with Variable IDs

[woody86]

Hello again!

 

I'm trying to update multiple rows on my database using one form. The problem is that the number of rows on the form is variable, and the ID for each row is also variable...

   $Team = $_GET['Team'];
   $Game = $_GET['Game'];
   $result = mysql_query("SELECT * FROM data WHERE Team='$Team'",$db);
   while($myrow = mysql_fetch_array($result)) {

echo '<input type="hidden" name="PlayerID" Value="', $myrow["PlayerID"], '">', '<input type="hidden" name="Game" Value="', $Game, '">', $myrow["Team"], ' - ', $myrow["PlayerName"], ' - ', $myrow["Owner"], ' - Points:<input type="Text" size="5" name="Points" value="', $myrow["$Game"], '"><br>';
}
?>

That is my form. When I POST the data I only get the data from the last row that is echoed. I assume that the problem is that the names of my inputs are static and will be overwritten each line, but if I change them to a variable, how can I tell my form to know what they are on the other side? From my limited knowledge it looks like I want to pass an array through POST, just don't know how to do that!

 

Thanks for any help