Updating multiple records via checkbox

[bluns]

Hi all, i wish to use checkboxes to update multiple values in my columns.

I get this error

Warning: implode(): Bad arguments. in c:\documents and settings\dev\my documents\root\site\admin\featured.php on line 47
Error encountered: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

non working update code

 
$id2=$_POST['featured'];
  $query='UPDATE data SET featured=true where id IN ('. implode(', ', $id2).')';
    $result = mysql_query($query); 

I based this code on my delete multiple records code. But for some reason that code works fine

Ill display it anyways, maybe it will help

working delete code

 
$id2=$_POST['to_delete'];
  $query='DELETE FROM data WHERE id IN ('. implode(', ', $id2).')';
  mysql_query($query);
  $result = mysql_query($query); 

Anyone know what is wrong with my syntax?

Thanks

[lilleman]

It seems like $_POST['featured'] is not an array. You have to name your checkboxes "featured[]" in your form, otherwise it won't become an array when the form is posted.

-- lilleman