Re: Delete Multiple Records From Checkboxes

On May 26, 2004, at 7:55 PM, Tom Rogers wrote:

Hi, Thursday, May 27, 2004, 11:34:03 AM, you wrote: AP> I've checked the archives and several other sources, but still can't AP> seem to make this work. AP> I have a form with checkboxes to designate records to be deleted from AP> the mysql database. The pertinent form code is: AP> <input type=\"checkbox\" name=\"del[]\" value=\"" . $row['id'] . "\"> AP> The processing code is: if (count($del) >> 0){ AP> for ($i=0;$i<count($del);$i++){ AP> $query = "DELETE FROM ref_events_reg WHERE id = '$del[$i]'"; AP> } AP> } AP> Echoing the query produces: AP> DELETE FROM ref_events_reg WHERE id = A AP> I've also tried the following: AP> $query = "DELETE FROM ref_events_reg WHERE id IN ('" . implode("','", AP> addslashes($del)) . "')"; AP> This one produces a warning: AP> Warning: implode(): Bad arguments. AP> and the following query: AP> DELETE FROM ref_events_reg WHERE id IN ('') AP> Both attempts fail to delete any records even though several records AP> are checked. AP> Where have I gone wrong? AP> Thanks. AP> Albert Padley change it to <input type=\"checkbox\" name=\"del[$row['id']]\" value=\"Y"\"> Then you can do something like foreach($del as $id=>$val){

     $query = "DELETE FROM ref_events_reg WHERE id = '$id'";
     //do query

} -- regards, Tom Tom,

When I tried this I received a warning - Warning: Invalid argument supplied for foreach() and, of course, no records were deleted. Albert Padley