Deleting multiple Rows Using Checkbox

[arizal]

Hi ,
I am trying to figure out why my PHP code to delete multiple value by selecting the checkbox is not working. My php code is listed as below

[PHP]
<?php
$sql = "Select * from list;";
$result=mysql_query($sql) or die ("<br> Could not Retrieve Data <br>");
$num_rows=mysql_num_rows($result);

While ($row =mysql_fetch_array($rs))
{
$currentCom_id = $row["com_id"];
?>

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

}
?>

<input name="delete" type="submit" id="delete" value="Delete">
[/PHP]

Now for deleting the selected checkbox i have used following SQL queries.

[PHP]

if($_POST['delete'] == "Delete"){
for($j=0;$j<$num_rows;$j++){
$del_id = $checkbox[$j];
$sql = "DELETE FROM committee WHERE com_id='$del_id'";
$result = mysql_query($sql);
echo $result;
}
}
mysql_close();
?>

[/PHP]

The problem is when i press delete it does not deletes the rows selected, else it just reloads the page. I dont know where i am wrong.

can u guyz please help me on this ...
THanks

[code green]

Looks like you are expecting the GLOBAL post vars to be switched on. It is switched off by default in later versions of php. You should not use this anyway. You need to read the checkbox values through the $_POST array

[forjaes]

Hi,

i'm gaing the same problem... I change my code to that:

<?
// Check if delete button active, start this
if($_POST['delete'] == 'Delete'){
for($i=0;$i<$count;$i++){
$del_id = $_POST['checkbox'][$i];
$sql = "DELETE FROM $tbl_name WHERE userid='$del_id'";
$result = mysql_query($sql);
}


// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>


But it still doesn't work...

Please help.
thx.

[epots9]

what errors are u getting?

[rkarim1981]

Hi, If any one didn't got the solution yet of this problem and still seeking! Please mail me on DELETED