> 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

Reply via email to