Re: Checkboxes to gather rows to delete

It is wrong to use that way of doing it John, cause this will delete ALL lines that where printed with a checkbox And also, if you are using a old version of PHP with register globals OFF, the _POST array will not be available Mathieu Dumoulin "1lt John W. Holmes" <holmes072000@charter.net> a écrit dans le message de news: 000b01c2dc1c$22449470$a629089b@TBHHCCDR... > > 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... >