Updating Multiple Records Based on A checkbox in a Repeated
Posted: Thu Dec 09, 2004 11:17 am
Question for the Pros:
I want to display records in a database. A single Row will be made a repeat region to display all the records. Simple. In that row I also want a checkbox, next to each record. Based on the checkboxes checked, I want to UPDATE those records in the database. Here is the code to display my table.
I just need the code for updating based on the checkboxes.
I want to display records in a database. A single Row will be made a repeat region to display all the records. Simple. In that row I also want a checkbox, next to each record. Based on the checkboxes checked, I want to UPDATE those records in the database. Here is the code to display my table.
Code: Select all
<?php do { ?>
<tr align="left" valign="middle" bgcolor="#FFFFFF">
<td align="center" valign="middle" class="style16"><input name="checkbox" type="checkbox" value="checkbox"></td>
<td class="style16"><?php echo $row_Log_Displayї'date_created']; ?></td>
<td class="style16"><?php echo $row_Log_Displayї'event']; ?></td>
<td class="style16"><?php echo $row_Log_Displayї'region']; ?></td>
<td class="style16"><?php echo $row_Log_Displayї'quanity_sets']; ?> Sets of <?php echo $row_Log_Displayї'quanity_each']; ?> Each </td>
<td><span class="style16"><?php echo $row_Log_Displayї'size']; ?> <?php echo $row_Log_Displayї'sort']; ?></span></td>
<td><span class="style16"><?php echo $row_Log_Displayї'description']; ?></span></td>
<td class="style16"><span class="style16 style19"><span class="style21"><?php echo $row_Log_Displayї'status']; ?></span></span></td>
</tr>
<?php } while ($row_Log_Display = mysql_fetch_assoc($Log_Display)); ?>