Error with query

[lilman]

I am dumbfounded by this error I am getting.  It all looks right, so I cannot figure out why it won't execute.  Here is the code, and then the error I am getting.

 

$sql = "INSERT INTO pandoris_hotornot_comments (canidate_id, score, hot, not) VALUES ('$user_picture_id', '$score', '$hot', '$not')";

$run = mysql_query($sql) or die("Error ". mysql_error() ." with query ". $sql);

 

Error:

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 'not) VALUES ('1', '4', 'hot', 'not')' at line 1 with query INSERT INTO pandoris_hotornot_comments (canidate_id, score, hot, not) VALUES ('1', '4', 'hot', 'not')

 

[zzman]

not is a mysql function. 1st of all you should not use it as a field name. If you do you need to put it in quotes `not`.