[SOLVED] mysql read from checkboxes.. foreach?

[Dragen]

Okay, I've got this code to create a checkbox...

<?php
echo "<input type=\"checkbox\" name=\"id\" value=\"" . $row['id'] . "\" />"
?>

On the form I usually end up with at least two or three checkboxes using a a while statement to read from a database. The only difference is the value, which are all numerical.

When the form gets processed it goes through this code:

$sql = "DELETE FROM " . $type . " WHERE id = '" . $_POST['id'] . "'";

Which gets the id from the checkbox and deletes that row in the table.

The problem is if I select more than one checkbox it only deletes the last one and not the others... I presume I'd need a foreach statement to go through all the checked ones, but I'm not sure how to do so.

If anyone can help?

Thanks

[Barand]

You need

<?php
echo "<input type=\"checkbox\" name=\"id[]\" value=\"" . $row['id'] . "\" />"
?>

 

NOTE: name=id[]

 

To process

$idlist = join (',' , $_POST['id']);    // eg gives "1,3,7"

mysql_query ("DELETE FROM table WHERE id IN ($idlist)");

[Dragen]

ah.. I thought I might have to set the name as an array...

and using the join is good! I didn't think of that although I'm using implode instead.. purely because I'll remember it easier.

 

Thanks!