Multiple form update

[amwd07]

Please help someone  ???

I am having trouble being able to update multiple records using checkboxes

 

<form method="POST" action="<?php echo $editFormAction; ?>" name="ratings">
<table border="1" align="center" cellpadding="8" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#F4F4F4">
  <tr>
    <td bgcolor="#FFEEAA"><strong>name
        <input name="rating_id" type="hidden" id="rating_id" value="<?php echo $row_rsRatings['rating_id']; ?>" />
    </strong></td>
    <td bgcolor="#FFEEAA"><strong>email</strong></td>
    <td bgcolor="#FFEEAA"><strong>postcode</strong></td>
    <td bgcolor="#FFEEAA"><strong>ratings</strong></td>
    <td bgcolor="#FFEEAA"><strong>created</strong></td>
    <td bgcolor="#FFEEAA"><div align="center"><strong>onhold</strong></div></td>
    <td bgcolor="#FFEEAA"> </td>
  </tr>
<?php 
do { 
$rateid = $row_rsRatings['rating_id'];
$rateposted = $_POST['onhold'.$rateid];
print_r($rateposted);

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "ratings")) {
  $updateSQL = sprintf("UPDATE restaurant_ratings SET onhold=%s WHERE rating_id=%s",
                       GetSQLValueString(isset($rateposted) ? "true" : "", "defined","1","0"),
                       GetSQLValueString($_POST['rating_id'], "int"));

  mysql_select_db($database_connDW, $connDW);
  $Result1 = mysql_query($updateSQL, $connDW) or die(mysql_error());
}
?>
    <tr>
      <td><strong><?php echo $row_rsRatings['name']; ?></strong></td>
      <td><?php echo $row_rsRatings['email']; ?></td>
      <td><?php echo $row_rsRatings['postcode']; ?></td>
      <td><?php echo $row_rsRatings['ratings']; ?></td>
      <td><?php echo $row_rsRatings['created']; ?></td>
      <td><div align="center">
        <input type="checkbox" name="onhold<?php echo $rateid ?>" id="onhold<?php echo $rateid ?>" value="1" <?php if (!(strcmp($row_rsRatings['onhold'],1))) {echo "checked=\"checked\"";} ?> />
        <?php echo $rateid ?></div></td>
      <td><input type="submit" name="rateupdate" id="rateupdate" value="Update" /></td>
    </tr>
    <?php } while ($row_rsRatings = mysql_fetch_assoc($rsRatings)); ?>

</table>
</form>

[amwd07]

I have changed my code so the $editforaction is not in the loop

and still can't work this one out all I want to do is update more than 1 record with each record having it's own update button ?

 

<form method="POST" action="<?php echo $editFormAction; ?>" name="ratings">
<table border="1" align="center" cellpadding="8" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#F4F4F4">
  <tr>
    <td bgcolor="#FFEEAA"><strong>name</strong></td>
    <td bgcolor="#FFEEAA"><strong>email</strong></td>
    <td bgcolor="#FFEEAA"><strong>postcode</strong></td>
    <td bgcolor="#FFEEAA"><strong>ratings</strong></td>
    <td bgcolor="#FFEEAA"><strong>created</strong></td>
    <td bgcolor="#FFEEAA"><div align="center"><strong>onhold</strong></div></td>
    <td bgcolor="#FFEEAA"> </td>
  </tr>

<?php 
do { 
$rateid = $row_rsRatings['rating_id'];
$rateposted = $_POST['onhold'.$rateid];
print_r($rateposted);
?>
  <tr>
  <td><strong><?php echo $row_rsRatings['name']; ?></strong></td>
      <td><?php echo $row_rsRatings['email']; ?></td>
      <td><?php echo $row_rsRatings['postcode']; ?></td>
      <td><?php echo $row_rsRatings['ratings']; ?></td>
      <td><?php echo $row_rsRatings['created']; ?></td>
      <td>
<div align="center">
<input name="rating_id" type="hidden" id="rating_id" value="<?php echo $rateid ?>" />   
<input type="checkbox" name="onhold<?php echo $rateid ?>" id="onhold<?php echo $rateid ?>" value="1" <?php if (!(strcmp($row_rsRatings['onhold'],1))) {echo "checked=\"checked\"";} ?> />
<?php echo $rateid ?></div></td>
<td><input type="submit" name="rateupdate" id="rateupdate" value="Update" /></td>
</tr>
<?php } while ($row_rsRatings = mysql_fetch_assoc($rsRatings)); ?>
</table>
</form>

[amwd07]

Please I really need help with this