Posted by Curtis on 12/12/06 09:58

It would be better to just execute one query, rather than executing a
query on each iteration. First, form the query from the submitted data,
then execute:

<?php
// sanitize input
foreach ( $_POST['delete'] as $key => $val )
$_POST['delete'] = intval($val);

// init query
$qry = 'DELETE FROM `table` WHERE `id` = ';
$id = implode(' OR `id` = ', $_POST['delete']); // extend string from
submitted ids
$qry .= $id; // concatenate

$sql = mysql_query($qry); // run query

// do what you need with the sql resource
?>

On Dec 11, 12:13 am, "ameshkin" <amir.mesh...@gmail.com> wrote:
> What I want to do is very simple, but I'm pretty new at PHP and its a
> little hard for me.
>
> I have one page, where there are a rows of checkboxes. A button
> selects all checkboxes, and then presses delete.
>
> When delete is pressed, I want to go to a next page and run a sql
> command for every single box thats checked. The checkboxes store a
> value, and multiple boxes can be checked.
>
> On the second page, whch is the form actin, I simply want to iterate
> through and pull which values are checked and run a sql command for
> each value.
>
> I have no idea how to do this. I assume you willl have to use a for
> each statement, but am having trouble programming this.
>
> Someone please help!

[Back to original message]