Multiple update records does not work. Please help
I have been trying to create a simple multi update page but it does not update my records.
I have been reading some threads were people have had the same problem I am having right now. I follow their solution in rearranging the code that gets written in the side the form but no luck. Below is the original code the wizard wrote on my page.
<form action="" method="post">
<table border="1">
<?php do { ?>
<tr>
<?php
// RepeatSelectionCounter_1 Begin Loop
$RepeatSelectionCounter_1_IterationsRemaining = $RepeatSelectionCounter_1_Iterations;
while($RepeatSelectionCounter_1_IterationsRemaining--){
if($RepeatSelectionCounterBasedLooping_1 || $row_Recordset1){
?>
<td>QTy</td>
<td><input type="hidden" name="WADA_RepeatID_detailsID_<?php echo $RepeatSelectionCounter_1; ?>" id="WADA_RepeatID_detailsID_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo $row_Recordset1["detailsID"]; ?>" />
<input name="qty_<?php echo $RepeatSelectionCounter_1; ?>" type="text" id="qty_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo $row_Recordset1['quantity']; ?>" /></td>
<?php
} // RepeatSelectionCounter_1 Begin Alternate Content
else{
?>
<td>No records match your request.</td>
<?php } // RepeatSelectionCounter_1 End Alternate Content
if(!$RepeatSelectionCounterBasedLooping_1 && $RepeatSelectionCounter_1_IterationsRemaining != 0){
if(!$row_Recordset1 && $RepeatSelectionCounter_1_Iterations == -1){$RepeatSelectionCounter_1_IterationsRemaining = 0;}
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
$RepeatSelectionCounter_1++;
} // RepeatSelectionCounter_1 End Loop
?>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
<input type="submit" name="button" id="button" value="Submit" />
<br />
</form>