Delete With CheckBox POST

[arizal]

Hi,
I am having some problem trying to think how to write a code for deleting the entry which is loaded from the database. I have a while loop which pulls the userID, name etc from the database and i have a checkbox next to each useriD. I also have a Delete button. SO what i want is when delete is clicked it will delete all items which are checked.
My code

[PHP]
<?php $a=0;
$i=0;
While ($row =mysql_fetch_ar ray($rs))
{
$currentCom_id = $row["com_id"];
?>
<TR style="COLOR: #333333; BACKGROUND-COLOR: #d7d6d3">
<TD><A style="COLOR: #333333"
href="adminlogi n.php?mode=comm _del">Edit</A></TD>
<td><input type="checkbox" name="checkbox_ <?php echo $i; ?>" value= <?php echo $currentCom_id ;?>>
</td>
<TD><?php echo $a=$a+1 ; ?> </TD>
<TD><?php echo $row["com_name"] ;?></TD>
<TD><?php echo $row["com_note"] ;?></TD>
<input type="hidden" name= comId_<?php echo $i; ?> value="<?= "$currentCom_id " ?>">

</TR></TBODY>
<?php
$i=$i+1;
}

[/PHP]

So the above code runs fine. SO i am having some problem on how to know which checkbox user checked. SHould i use foreach loop or other way.
PLease help me on this.
Thanks

[iam_clint]

name all of the checkboxes the same then submit the form and in your php get the name of the checkboxes and loop through to see which ones are checked.

[ak1dnar]

Put your while loop inside a form.then create a array of check boxes.
and always pass the userid in value attribute.

[PHP]<input type="checkbox" name="frm_chk_d elete[]" value="'.$id.'" />[/PHP]

then from the action page.fetch the array.

[PHP]$frm_chk_delete = $_REQUEST['frm_chk_delete '];[/PHP]

the implode the array.

[PHP]$list_of_ids = implode(",", $frm_chk_delete );[/PHP]

use this kind of query to delete your user ids.
[PHP]mysql_query("DE LETE FROM cart WHERE p_id IN ($list_of_ids)" );[/PHP]