I got this error after finished a game and trying to view the score!
PHP Code:
SELECT arcade_sessions.*, user.username FROM vb3_arcade_sessions AS arcade_sessions
LEFT JOIN vb3_user AS user ON (user.userid=arcade_sessions.userid)
WHERE arcade_sessions.valid=1 AND arcade_sessions.gameid=119 AND ()
ORDER BY score DESC, arcade_sessions.finish DESC
LIMIT 10;
MySQL 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 ')
ORDER BY score DESC, arcade_sessions.finish DESC
LIMIT 10' at line 3
Error Number : 1064
I'm using php version 4.4.1 and MySQL 4.1.14