[Cheney]

I need help using checkboxes to delete mutliple entrys, everything connects right and such, just it keeps saying the array is empty

<FORM ACTION="deletepost.php"><?php

include('db.php');

$q = mysql_query("SELECT * FROM $table ORDER BY id DESC LIMIT $limit");

while($r=mysql_fetch_array($q)){

$news = $r["message"];

$id = $r["id"];

$author = $r["author"];

echo "<FORM ACTION=\"deletepost.php\">

<table border=\"1\" align=\"center\" width=\"760\">

<tr align=\"center\"><td>

<INPUT TYPE=CHECKBOX NAME='delete[]' value ='$id' method= 'post'>Delete a Post!

<P>

<td width = \"500\">$author<br>$news</td></tr></table>
";
}
?>
<p align = "center">
<INPUT TYPE=SUBMIT VALUE="Submit">
</FORM>

deletepost.php:

<?php

include ('db.php');

$post =$_POST['delete'];

echo $post;

foreach($post as $iddelete) {

mysql_query("DELETE FROM news WHERE id='$iddelete'");
}
die("<pre>".print_r($_POST,True));
?>

?>

Warning: Invalid argument supplied for foreach() in /home/cheney/public_html/deletepost.php on line 9

Array
(
)

Thats the error I get

[ArksI]

why don't you simply use:
1. method="POST"
2.
foreach($_POST[$delete] as $value) {

mysql_query("DELETE FROM news WHERE id='$value'");
}

[Acecool]

if a checkbox is checked, it is "on", else it is ""

[irfanbaba]

use following for deletepost.php

********Code Begin here*********
<?php

include ('db.php');

$post =$_POST['delete'];

/*If no entries are checked for deletion, display error*/

if (!$post) { errorMultiple(); exit; }


/*Now Loop through entries and delete checked ones*/
foreach ( $post as $goodbye )

{
mysql_query("DELETE FROM news WHERE id = '$goodbye'");

}


/*Display message*/

multipleDeleted();
exit;


function multipleDeleted() {

Echo "Record(s) Deleted Succesfully.";
}


function errorMultiple() {

Echo "Please select records first.";
}

?>

keep posting if again getting error

[mentalray]

Cheney you have a html error no PHP,
this part:

<FORM ACTION="deletepost.php"><?php

include('db.php');

$q = mysql_query("SELECT * FROM $table ORDER BY id DESC LIMIT $limit");

while($r=mysql_fetch_array($q)){

$news = $r["message"];

$id = $r["id"];

$author = $r["author"];

echo "<FORM ACTION=\"deletepost.php\">

<table border=\"1\" align=\"center\" width=\"760\">

<tr align=\"center\"><td>

<INPUT TYPE=CHECKBOX NAME='delete[]' value ='$id' method= 'post'>Delete a Post!

<P>

<td width = \"500\">$author<br>$news</td></tr></table>
";
}
?>
<p align = "center">
<INPUT TYPE=SUBMIT VALUE="Submit">
</FORM>

must be like this:

<FORM ACTION="deletepost.php" method= "post"><?php

include('db.php');

$q = mysql_query("SELECT * FROM $table ORDER BY id DESC LIMIT $limit");

while($r=mysql_fetch_array($q)){

$news = $r["message"];

$id = $r["id"];

$author = $r["author"];

echo "<table border=\"1\" align=\"center\" width=\"760\">

<tr align=\"center\"><td>

<INPUT TYPE=CHECKBOX NAME='delete[]' value ='$id' >Delete a Post!

<P>

<td width = \"500\">$author<br>$news</td></tr></table>
";
}
?>
<p align = "center">
<INPUT TYPE=SUBMIT VALUE="Submit">
</FORM>

because you printed the <FORM> tag two times and you are using $_POST[] in your delete PHP file you have to assign post method to the form, no in the checkbox

[sham85131]

<input type="checkbox" name="checkbox[]" value="<? echo $row2['prd_code']; ?>" id="checkbox">

just give id field in that tag. see,may it will solve this problem.