Quote:
Originally Posted by Shadows Adi
PHP Code:
SELECT ROW_NUMBER() OVER (ORDER BY 1.0 * kills / deaths DESC), Pos, kills, deaths, auth FROM tablename WHERE enabled = 1 AND kills > 0 AND deaths > 0 AND kills > 100;
You forgot a comma after
|
I believe that is not the problem, even because when adding the comma (which does not make sense in the syntax) the querie does not even return in the program.
Edit 1:
Error code is 1..
Code:
(1) SQLITE_ERROR
The SQLITE_ERROR result code is a generic error code that is used when no other more specific error code is available.
__________________