I have this multiple update forum that when submitted the Q1-Q5 are questions that you can enter in answers to questions, when submitted if I answer Q1-Q5 on a record that is not the first one, it displays the answers on the first record. The check boxes work just fine when there is only one of them but the multiple ones do not. Any help is appreciated. Here is the code:
<?php
mysql_connect("");
mysql_select_db("");
$query = "SELECT * FROM KEYCAD WHERE HOLD LIKE 'N' AND DEACTIVATE LIKE '0' ORDER BY CUSTOMERNAME,CONTACTDATE DESC";
$result = mysql_query($query);
echo "<form method='post' action='submit.php?action=change'>";
while ($row = mysql_fetch_array($result)){
echo "<table border=2 bordercolor=#5E3964>\n";
echo "<tr>
<td><font color=#FF0000>Name</font></td>
<td><font color=#FF0000>Home #</font></td>
<td><font color=#FF0000>Work #</font></td>
<td><font color=#FF0000>Car Model</font></td>
</tr>\n";
printf("
<tr>
<input type='hidden' name='RO[]' value='%s'>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
</tr>\n",
$row["RO"],
$row["CUSTOMERNAME"],
$row["HOMEPHONE"],
$row["BUSPHONE"],
$row["MODEL"]
);
echo "<tr>
<td><font color=#FF0000>Hot Spot</font></td>
<td><font color=#FF0000>Fixed Correctly?</font></td>
<td><font color=#FF0000>Treatment?</font></td>
<td><font color=#FF0000>Clear Explanation?</font></td>
</tr>\n";
printf("
<tr>
<td><input type=checkbox name='FOLLOWUPCONTACT[]' value='Y'><input type=hidden name='FOLLOWUPCONTACT[]' value='N'></td>
<td><input type='radio' name='Q1[]' value='Y'>Y<input type='radio' name='Q1[]' value='N'>N</td>
<td><input type='radio' name='Q2[]' value='Y'>Y<input type='radio' name='Q2[]' value='N'>N</td>
<td><input type='radio' name='Q3[]' value='Y'>Y<input type='radio' name='Q3[]' value='N'>N</td>
</tr>\n",
$row[""]
);
echo "<tr>
<td><font color=#FF0000>Overall Service?</font></td>
<td><font color=#FF0000>Why Not Fixed?</font></td>
<td><font color=#FF0000>Comments</font></td>
<td><font color=#FF0000>Happy</font></td>
</tr>\n";
printf("
<tr>
<td><input type='radio' name='Q4[]' value='Y'>Y<input type='radio' name='Q4[]' value='N'>N</td>
<td><input type='radio' name='Q5[]' value='1'>1<input type='radio' name='Q5[]' value='2'>2<input type='radio' name='Q5[]' value='3'>3<input type='radio' name='Q5[]' value='4'>4<input type='radio' name='Q5[]' value='5'>5</td>
<td><input type=text name='COMMENTS[]' value='%s'></td>
<td><input type=checkbox name='HAPPY[]' value='1'></td>
</tr>\n",
htmlentities($row["COMMENTS"],ENT_QUOTES)
);
echo "<tr>
<td><font color=#FF0000>Close Date</font></td>
<td><font color=#FF0000>Deactivate</font></td>
<td><font color=#FF0000>Keep in Pending</font></td>
<td><font color=#FF0000>Submit</font></td>
</tr>\n";
printf("
<tr>
<td>%s</td>
<td><input type=checkbox name='DEACTIVATE[]' value='1' onclick=\"return confirm('ARE YOU SURE YOU WANT TO DEACTIVATE THIS CUSTOMER?')\"></td>
<td><input type=checkbox name='HOLD[]' value='N' CHECKED></td>
<td><input type=checkbox name='HOLD[]' value='Y'></td>
</tr>\n",
$row["CLOSEDATE"]
);
}
echo "</table>";
echo "<input type=submit name=submit value=Submit>\n";
echo "</form>";
?>
And here is the submit.php
<?php
$RO = $_POST['RO'];
$HOLD = $_POST['HOLD'];
$Q1 = $_POST['Q1'];
$Q2 = $_POST['Q2'];
$Q3 = $_POST['Q3'];
$Q4 = $_POST['Q4'];
$Q5 = $_POST['Q5'];
$COMMENTS = $_POST['COMMENTS'];
$DEACTIVATE = $_POST['DEACTIVATE'];
$FOLLOWUPCONTACT = $_POST['FOLLOWUPCONTACT'];
$HAPPY = $_POST['HAPPY'];
mysql_connect("208.185.185.229","a0020386","brumbr50");
mysql_select_db("a0020386");
for($i = 0; $i < count($RO); $i++){
$query = "UPDATE KEYCAD SET HOLD='$HOLD[$i]', Q1='$Q1[$i]', Q2='$Q2[$i]', Q3='$Q3[$i]', Q4='$Q4[$i]', Q5='$Q5[$i]', COMMENTS='$COMMENTS[$i]', DEACTIVATE='$DEACTIVATE[$i]', FOLLOWUPCONTACT='$FOLLOWUPCONTACT[$i]', HAPPY='$HAPPY[$i]' WHERE RO='$RO[$i]'";
print $query."<br />";
$result = mysql_query($query) or die(mysql_error());
}
?>
