Need working example of checkbox delete

Anon

I have read everything I could find on this forum and on the web about using checkboxes to delete records. I am using following code:

Everything shows up fine, and pulls the records from the database. The problem is that I now need to delete the id in the database according to which checkbox is ticked. I find bits and peices of code and explanations all over the place, but everything I try causes errors, or doesn't delete the record although it APPEARS to run despite error checking.

Surely deleting a record from a database by a checkbox has been done before now, but I have found no working, complete examples.

I need to see a working example to understand how all the bits and pieces go together. Can anyone point me to a working example WITH CODE where the value of the checkbox is the value associated with the record ID?
Thanks,
Cindy

toma42

http://ets.dhs.org/admin/

index.phps in source does deleting using checkboxes.

Anon

Thanks Tom.
Jamie Thompson has a pretty good explanation at http://www.phpbuilder.com/forum/read.php3?num=1&id=117072&loc=0&thread=11265

I used his code to get the following because it was simple, explained nicely and works!

function getcheckboxes ($checkbox)
{
foreach($checkbox as $value) {
$values .= "," . $value;
}
$values = substr($values, 1);
return($values);
}

	$result = getcheckboxes($adsID); 

	$sql = "DELETE FROM tbl_Name WHERE recordID IN ($result)";

	//execute SQL query and get result
	$sql_result = mysql_query($sql)	or die("Couldn't execute query.");