Problem in Loop with Multiple Update

[cinematic_jesi]

I'm trying to provide a much faster way of verifing information, therefore I would like to do a multiple update rather than having to edit each record one at a time.

Which leads me to my test:

<?php
$sql="SELECT * FROM FootballCamp LIMIT 10";
$result=mysql_query($sql);

// Count table rows
$count=mysql_num_rows($result);
?>
<title>Multiple Update Test</title>

<table width="500" border="0" cellspacing="1" cellpadding="0">
  <form name="form1" method="post" action="">
    <tr>
      <td><table width="500" border="0" cellspacing="1" cellpadding="0">
          <tr>
            <td align="center"><strong>ID</strong></td>
            <td align="center"><strong>Waiver Signed?</strong></td>
          </tr>
<?php while($rows=mysql_fetch_array($result)){ ?>
          <tr>
            <td align="center"><? $id[]=$rows['ID']; ?>
              <? echo $rows['ID']; ?></td>
            <td align="center"><input type="checkbox" id="WaiverSigned[]" name="WaiverSigned[]" value="1" /></td>
          </tr>
<?php } ?>
          <tr>
            <td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
          </tr>
        </table></td>
    </tr>
  </form>
</table>
<?php
// Check if button name "Submit" is active, do this
extract($_POST);
if($Submit){
for($i=0;$i<$count;$i++){
$sql1="UPDATE FootballCamp SET WaiverSigned='$WaiverSigned[$i]' WHERE ID='$id[$i]'";
//$result1=mysql_query($sql1);
echo $sql1 . '<br>';
}
}
mysql_close();
?>

For testing purposes I don't actually update the database, so to check my data I echo the sql statements that it creates.

And let's say I check 2 boxes (doesn't matter which ones) it will only update the first two records with 1 and the rest will be 0 even if I didn't choose them.

And it would output this:

UPDATE FootballCamp SET WaiverSigned='1' WHERE ID='19'
UPDATE FootballCamp SET WaiverSigned='1' WHERE ID='18'
UPDATE FootballCamp SET WaiverSigned='' WHERE ID='17'
UPDATE FootballCamp SET WaiverSigned='' WHERE ID='16'
UPDATE FootballCamp SET WaiverSigned='' WHERE ID='15'
UPDATE FootballCamp SET WaiverSigned='' WHERE ID='14'
UPDATE FootballCamp SET WaiverSigned='' WHERE ID='13'
UPDATE FootballCamp SET WaiverSigned='' WHERE ID='12'
UPDATE FootballCamp SET WaiverSigned='' WHERE ID='11'
UPDATE FootballCamp SET WaiverSigned='' WHERE ID='10'


Any ideas???

Thanks

[cinematic_jesi]

Okay so I switched it with textfields and it worked fine if I manually inputted 0 or 1. So its something wrong with my checkboxes.. ..

[cinematic_jesi]

bump?