Updating Multiple Records

[skipper2]

Hello, I have a MySQL db which contains a number of fields including username and password. These are entered into the db when someone signs up for service, however there is another field called 'active'. The default value for this field is 'n' so that the account is not activated until I activate it. In my admin area I have a list of all of the clients that have the value of 'active' set to 'n'. The records are repeated with a repeat records function. I have the record id which is 'id' as a hidden field on each row. I would like to activate the ones I chose with a checkbox or radio-button by setting the checked value to 'y'. I can update 1 record this way but not all of the ones I have selected. Here is the code I have so far. Thank you for any help.
Mike

<form name="form1" method="POST" action="<?php echo $editFormAction; ?>">
<table width="80%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>&nbsp;</td>
<td class="head1">Company</td>
<td class="head1">First Name</td>
<td class="head1">Last Name </td>
<td class="head1">Activate</td>
</tr>
<?php do { ?>
<tr>
<td><input name="hiddenField" type="hidden" value="<?php echo $row_Recordset1['id']; ?>"></td>
<td class="text"><?php echo $row_Recordset1['company']; ?></td>
<td class="text"><?php echo $row_Recordset1['fname']; ?></td>
<td class="text"><?php echo $row_Recordset1['lname']; ?></td>
<td class="text">
<div align="left">
<input type="checkbox" name="checkbox" value="y">

</div></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
<p>
<input type="submit" name="Submit" value="Update">
</p>
<input type="hidden" name="MM_update" value="form1">
</form>

[zubinkasad]

Dont give value to checkbox by default it will give value of "on" and "off" so what you do is write a if condition

if ($checkbox=on)
{
give your update statement here
}
else
{
}

so when you click on checkbox its value will turn to on and than this if condition will evaluate to true.

[Roger_Ramjet]

Create an array for the checkbox names and give each the id as its value, then itterate through the array in the target script.

// on form
 <input type="checkbox" name="activate[]" value="<?php echo $row_Recordset1['id']; ?> ">  

<?
// in target script

$activate = $_POST['activate'];

$query = "UPDATE table SET active='y' WHERE id IN ( ";

for($i=0;$i<count($activate);$i++){
$query .= "$activate[$i],";
} 
// lose last comma and close brackets
$query = substr($query, 0, strlen($query)-1) . ")";
?>

No need for the hidden field this way

[skipper2]

Thanks guys,

Roger, I created the array as you suggested:

<input name="activate[]" type="checkbox" id="checkbox[]" value="<?php echo $row_Recordset1['id']; ?> ">  

I am just confused where I should put the second part of your suggestion. I tried here without success:

<?php$activate = $_POST['activate']; 

							$query = "UPDATE reseller SET active='y' WHERE id IN ( "; 

							for($i=0;$i<count($activate);$i++){ 
							$query .= "$activate[$i],"; 
										}
						    while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); 

						   $query = substr($query, 0, strlen($query)-1) . ")"; 

or is it supposed to go in here:

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE reseller SET active=%s WHERE id=%s",
                       GetSQLValueString(isset($_POST['checkbox[]']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString($_POST['hiddenField'], "int"));

  mysql_select_db($database_clients, $clients);
  $Result1 = mysql_query($updateSQL, $clients) or die(mysql_error());

  $updateGoTo = "index.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

Thanks,

Mike