Re: Checkboxes to gather rows to delete
| From: | 1LT John W. Holmes | Date: | Mon, 24 Feb 2003 15:48:10 +0000 |
| Subject: | Re: Checkboxes to gather rows to delete | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25867@lists.php.net to get a copy of this message | ||
> I have a mysql database with a table using one column as a primary key.
> (rowID). On a php page I use a query to list all of the rows of the table
> and have a checkbox beside each row that should be used to check if you
> would like to delete this row. Can someone give me an example using post
> to pull the boxes that need to be deleted.
Easy one.. :)
Make sure your checkboxes have the rowID as their value, then you can simply
do this:
$query = "DELETE FROM table WHERE rowID IN (" .
implode(',',$_POST['checkboxes']) . ")";
and run that query.
You'll end up with something that looks like this:
DELETE FROM table WHERE rowID IN (1,2,3,4,5)
where the numbers will come from only the checkboxes that you selected.
---John Holmes...