filburt1
11-21-2004, 04:03 PM
Error 1064 in MySQL is a syntax error. Look in your query for something like:
...AND foo = 0 AND bar = AND something...
or
...foo = 0, bar =, something =...
...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.
...AND foo = 0 AND bar = AND something...
or
...foo = 0, bar =, something =...
...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.