Error 1064 in MySQL is a syntax error. Look in your query for something like:
...and notice the bold parts where a column name is given but no value for the column. The vast majority of the time it is caused by trying to use a numeric value when the value is actually boolean, and because false evaluates to an empty string in PHP, you can get this error. Try wrapping the variable with http://www.php.net/intval
In any case, this error is very, very common, so please search extensively before posting.
No members have liked this post.