Deleting multiple checked lines

[Anon]

I needed a code to allow for multiple line deletion. I found this code, and thought I had it implemented properly, but it doesn't delete the checked line.

Can someone tell me what is wrong?

Thanks,

On the first page, I have:

<?php
function LoanProgram() {
global $table_us_schools;

$resultSet = mysql_query("SELECT ID,SchoolName,StateCode,SchoolCode
FROM $table_us_schools
ORDER BY SchoolName");
while (list($ID,$SchoolName,$StateCode,$SchoolCode) =
mysql_fetch_array($resultSet)) {
echo("<tr>
<td class=\"text12blk\">$SchoolName</td>
<td class=\"text12blk\">$StateCode</td>
<td class=\"text12blk\">$SchoolCode</td>
<td>&nbsp;&nbsp;</td>
<td class=\"text12blk\"><input type=\"checkbox\" name='DeleteItems[]' value=\"$ID\"></td>
</tr>");
}
}
LoanProgram()

?>

------On the second, receiving page:------

<?php
$csvID = implode($DeleteItems, ",");

$DeleteQuery = "DELETE FROM $table_us_schools
WHERE ID IN($csvID)";

echo"<div class=text12red>The Following Schools were deleted from the database:</div>
<div class=text10>$csvID</div>";

?>

Thanks,

Brett Taylor

[Anon]

Does the user you are connecting to the database with have permissions to delete on this table? If you aren't passing in a user then the web user is being used (usually nobody). Personally I never give my web user delete permissions, and use specific pages that I put alot of security on if I need to delete from the web.

[Anon]

I've never done this using IMPLODE, so maybe my method is clunky. But it works for me. Is it possible that your formatting isn't coming out the correct way? (I'll investigate the way you're trying it, for further education).

In the form I use a counter so that I know how many checkboxes I have so that your DeleteItems[] is DeleteItems[$i]. Then:

while($x = each($DeleteItems))
{

$csvID = $csvID . " '" . $x[1] . "',";
}

//remove the ending comma
$id_list = substr("$id_list", 0, -1);

$delete_query = "DELETE FROM $table_us_schools WHERE A1_id IN ($id_list)";

Regards

jonb

[Anon]

Thanks,

Still can't get it to work, but I will work a bit more with this.

Brett