update the database query

[abitshort]

I try to get my database update but it doesn't seems to work, doesn't give any error messages either. After I submit the clues fields just got empty, and the live feild stays the same.

 

I think it have to do with the serialize array that I used. Sorry, I'm new to this stuff. Please help me fix this query

 

<? } 
   if ($_POST["submit"])
   {
  $word = $_POST["word"];
  $live = $_POST["live"];
  $id = $_POST["id"];
  $clues = $_POST[serialize(array($c1, $c2, $c3, $c4, $c5))];

  $result = mysql_query("UPDATE taboo SET word='$word', $c1='$clues', $c2='$clues' $c3='$clues' $c4='$clues' $c5='$clues' live='$live' WHERE id=$id")or die(mysql_error());

}
}
?>

[isedeasy]

not sure if this will fix it but shouldn't

 

id=$id

 

read

 

id='$id'

 

[Philip]

Yeah. I think you're right. It has something to do with the serialization....

 

What are the values of $c1-5, is the POST field actually named the same value as the serialization?