Saturday, 17 August 2013

MySqli and PHP: Not in statement

MySqli and PHP: Not in statement

Im trying to get data by an mysqli query. Query looks like that:
SELECT * FROM pxldr_drawings
ORDER BY RAND()
WHERE id NOT IN (1,3,4,2)
LIMIT 1
But i get the following error message
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 'WHERE id NOT
IN (1,3,4,2) LIMIT 1' at line 3
I also tryed NOT IN ('1','3','4','2') and NOT IN(1,3,4,2), but it didn't
worked.
Thanks, LB

No comments:

Post a Comment