Re: Checkboxes to gather rows to delete

From: 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...

« previous php.db (#25867) next »