checkbox to delete item

[carisi_2000]

I have a form that when sent inserts the information from the form to a database. When a user selects a game from a dropdown box, the information populates the form in case they need to edit the game information. I would like to have a checkbox they can click if they want to delete a game from the website, because I would rather differentiate between "deleted items" than actually have them deleting information from the database. However, when they check the box, it is not sending anything to the database.

[rubric]

you should post a few parts from your code so we can spot your problem, but these are a few things you can check:

1. Make sure the checkbox has a name and value tag.
2. Make sure the delete query is printing correctly
3. Make sure the checkbox is within the form tags.
4. I can't think of anything else right now...

Rubric

[cgraz]

your checkboxes should be an array and the value of each should be the id of the record you want to delete in the database.

<input type="checkbox" name="var[]" value="4"><br>
<input type="checkbox" name="var[]" value="8"><br>
<input type="checkbox" name="var[]" value="13"><br>

then, to delete all the checked records

$query = mysql_query("DELETE FROM your_table WHERE id IN ('" . implode("','", $_POST['var']) . "')") or die(mysql_error());

I'd backup your data before doing anything. Just a good precaution.

Cgraz