[Edvin]

Hi guys:

pawn Код:

format( szQuery, sizeof szQuery, "SELECT `Name`,`GangKills` FROM `Accounts` ORDER BY (`GangKills`) WHERE `GangID` = '%d' DESC LIMIT 5", GangID );

I have this syntax, and when I use it, this appear in "debug.txt":

Код:

[18:35:27] errorid: 1064 | 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 'WHERE `GangID` = '2' DESC LIMIT 5' at line 1 | resultid: 22 | extraid: -80652920 | callback: OnQueryFinish | query: SELECT `Name`,`GangKills` FROM `Accounts` ORDER BY `GangKills` WHERE `GangID` = '2' DESC LIMIT 5

What is wrong?