Deleting Multiple with foreach

[micmac]

Hello
I'm trying to delete multiple entries from a mysql table using the following script:

variables are passed using:

<input type=\"checkbox\" name=\"checkbox[]\" value=\"$id\">

and....

<?
include ("include/header.inc.php");
include("include/dbconnect_dmoz.php");

if ($delete_checked) {
foreach ($_POST['checkbox'] as $value){ 
$delete = mysql_query("delete from $table where checkbox=$value",$db);
} 
?>
<META HTTP-EQUIV="refresh" CONTENT="1; URL=dmoz_results.php">
<?
}
?>

the error is:

Warning: Invalid argument supplied for foreach() in ..../results.php on line 13 

Any ideas greatly appreciated.
Cheers,
micmac

[rharter]

two thoughts come to mind,
try casting checkbox as an array, e.g.,
array($_POST['checkbox'])

also, you shoud quote your mysql
':.$value."'

good luck

[Weedpacket]

Originally posted by micmac
Hello
I'm trying to delete multiple entries from a mysql table using the following script:

Warning: Invalid argument supplied for foreach() in ..../results.php on line 13 

Any ideas greatly appreciated.
Cheers,
micmac [/B]

var_dump($_POST) and see what it says about 'checkbox'.

[briansol]

i would use a different method...

$sql="DELETE blah FROM blah WHERE BLAH_ID IN (";
foreach ($BLAH_ID as $v)
{
   $sql.="$v,";
}
//get rid of the last comma
$sql=substr($sql,0,-1);
$sql.=")";