这个sql中的错误是什么

Question

What is wrong with this query:

SELECT * FROM leaderboard WHERE ALREADYWON != '1' ORDER BY Score LIMIT 0,'$limit'

Code after it just throws errors:

Warning: Invalid argument supplied for foreach() in file ...

$limit definitely has a value, I'm echoing it out just before. I'm using Oracle.

Can anyone spot a syntax error?

Answer 1

ORACLE doesn't support LIMIT. I had to use this query

SELECT * FROM leaderboard 
WHERE rownum <= '$limit' 
AND ALREADYWON != '1' 
ORDER BY Score