> 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...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
