Checkbox form deleting

[Anon]

I'm trying to delete some table items wich are selected previous in a checkbox form. I'm not sure how to name the "value" and "name" of the form and how to retrieve them later. My retrieving code is:

foreach ( $HTTP_GET_VARS as $key => $value)
{
$borra = ("DELETE FROM menu_pral WHERE $key = $value");
mysql_query ($borra,$conecta);
}

Can anyone help me ?
Thanks for advance,

Christian

[[deleted]]

After submitting a form with checkboxes the output is variables with the same name as you gave the checkboxes, and the values you assigned to the checkboxes if they were checked.
Example:

If the form was submitted with
<INPUT TYPE="checkbox" NAME="name" VALUE="Lara" CHECKED>
<INPUT TYPE="checkbox" NAME="language" VALUE="php" CHECKED>
<INPUT TYPE="checkbox" NAME="topic" VALUE="nothing" >

Then the output would be:
$name=="Lara"
$language=="php"
$topic==" "

Hope this helps you

[Anon]

<input type=checkbox name=check[] value="first_element">
<input type=checkbox name=check[] value="second_element">
<input type=checkbox name=check[] value="third_element">

When you submit this form you get an array $check, so you can get its elements this way:

for($i=0;$i<count($check);$i++) {
print($check[$i]);
}

So similar way you cn delete your records in database:

for($i=0;$i<count($check);$i++) {
$borra = ("DELETE FROM menu_pral WHERE your_fiels = $check[$i]");
mysql_query ($borra,$conecta);
}

I'm not sure I understand details of your question,but if I do, that's great ;-)

Best regards

[fandelem]

mateusz is correct. the trick to deleting multiple elements (rather the easiest way) is to simply have the checkboxes listed under the same name with a '[]' following; this symbolizes to PHP that it is an array. this is also nice when having someone purchase multiple items via a checkbox form.

[Anon]

Mateusz,
It's less effective to call the count() method every time the loop is run. It'd be more effective to set a variable first, like:

$arraycount = count($array1);

for ($i=0; $i<$arraycount; ++$i)
{
...
}