Deleting multiple data from db via checkbox

[bluns]

Hi guys im having trouble with this one 🙁

i have multiple checkboxes to delete multiple articles

the process form is

 $id2=$_POST['id'];

 if($id2=$_POST['id'])
 {
  mysql_select_db($db_name);
  $query = "delete from data where id=$id2"; 
  $result = mysql_query($query); 
    if (!$result) 
   { 
    print "Error encountered: ".mysql_error();      

   } 
   //Tell user how many articles are deleted
  if ($result)
      echo  mysql_affected_rows().' article';
	  if(mysql_affected_rows()>1){echo 's';} 
	  echo ' successfully deleted from database.'; 
   }
   ?>

This works fine if you delete 1 article at a time, but not if you wish to delete multiple amounts.

[mrhappiness]

name all the choboxes as to_delete[] (the brackets are important)
the values of the checkboxes are the ids of the entries in your table

<input type ="checkbox" name="to_delete[]" value="45">
<input type ="checkbox" name="to_delete[]" value="5">
<input type ="checkbox" name="to_delete[]" value="785">

in your php-script do

if (isset($_POST['to_delete'])) //at least one checkbox was checked
  mysql_query('DELETE FROM table WHERE id IN ('. implode(', ', $_POST['to_delete']).')');

[bluns]

thankyou very much works like a charm 😃

btw do you know why my mysql_affected_rows() no longer works?

  mysql_select_db($db_name);
  if (isset($id2)) //at least one checkbox was checked 
  {
  $query='DELETE FROM data WHERE id IN ('. implode(', ', $id2).')';
  mysql_query($query);
  $result = mysql_query($query); 
  if (!$result) 
  { 
   print "Error encountered: ".mysql_error();      

  } 
   //Tell user how many articles are deleted
   else
   {
   echo  mysql_affected_rows().' article';
   if(mysql_affected_rows()>1){echo 's';} 
   echo ' successfully deleted from database.'; 
   }
 }
 

It says 0 rows are effected when multiple rows are indeed removed 🙁

[mrhappiness]

it's becvause you are doing the DELETE twice

the 1st delete really deletes the rows whereas the 2nd deletes doesn't delete any row at all (they are already deleted) and so mysql_affected_rows is 0