is there an error on this sql request?

Question

$sql=mysql_query("INSERT INTO admin_cont 
                  (contact_idemail , contact_timestamp , contact_objet , contact_message) 
                 VALUES 
                  ('".$_COOKIE['zzzzz']."', '$timestamp', '$objet', '$message' ") or die(mysql_error()); 

i keep getting the error:

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

cheers

Answer 1

Close ) for VALUES.

Answer 2

Try this.

$sql=mysql_query("INSERT INTO admin_cont (contact_idemail , contact_timestamp , contact_objet , contact_message) VALUES ('".$_COOKIE['zzzzz']."', '$timestamp', '$objet', '$message')");

As stated in the other answers, you need to close the mysql_query statement. Now you are using

or die(mysql_error()

as part of the query string.

Answer 3

You need to add a close parenthesis after '$message'

Answer 4

Once you fit your immediate error, you'll want to fix the fact that your query is tremendously insecure. You need to use parameterized queries or run your values through mysql_real_escape_string().