Help with bulk update?

[jjfletch]

I'd like to be able to update several items at once via checkbox selection, and I'm not sure how to go about it....

Basically, I've created a table via a query to my db, and I've printed out each row and included a checkbox for each.

I'd like to select as many checkboxes as needed and then click "Update", which will then set all the values to "Yes" in my db.

$query = "SELECT * FROM MyTable WHERE Status='On'";
$result = mysql_query($query);

while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

$id = $row['OfferID']; 
$row_color = ($row_count % 2) ? $color1 : $color2;

echo "<tr valign=\"top\" height=\"40\">";
echo "<td bgcolor=\"$row_color\">{$row['ID']}</td> 
        <td bgcolor=\"$row_color\">{$row['Headline']}</td>

    <td align=\"center\" bgcolor=\"$row_color\"> 
    <input type=\"checkbox\" name=\"thisOK[]\" value=\"Yes\">
    </td></tr>"; 

$row_count++;

} 
        echo "<tr><td colspan=\"8\"><input type=\"submit\" name=\"update\" value=\"Update\"></td></tr>";
        echo "</form>"; 
?>
[code=php]

I want it to set the value to Yes for each record (identifed by the {$row['ID']}) for which I've checked the box.

Am I making sense?  Can someone tell me how to do this?

[Cent]

Here's a code snippet of something similar I've done to allow people to check off the messages they want to delete. In my case each of the checkbox's value is a unique message ID.

ie. <input type="checkbox" name="msgID[]" value="43b031c01857e">

$msgArray = $_POST['msgID'];

foreach ($msgArray as $thisMsgID) 
{
	$query = "DELETE FROM messages WHERE msgID='$thisMsgID'";
	@mysql_query($query);
}

You'll probably want to use FOREACH to handle your form array.

PHP.NET - Foreach

Best,
Cent

[jjfletch]

Ah, thanks. I found a working solution, but like yours better. 🙂 I'll try to implement that one.