sql error in php.....

Junior Spellweaver
Joined
Mar 14, 2018
Messages
159
Reaction score
13
hey guys i want to create a simple query to find only a few rows from an sql table and view it on my website.. i want to use limit but it doesnt work... this is the sql:
PHP:
odbc_exec($GLOBALS['dbconn'], "SELECT dwCharID, dwTotalPoint FROM TGAME_GSP.dbo.TPVPOINTTABLE ORDER BY dwTotalPoint DESC LIMIT 1");

the error:

if i delete "LIMIT 1" everything works...
 
Junior Spellweaver
Joined
Mar 14, 2018
Messages
159
Reaction score
13
yea its microsoft sql server... and is there anything similar to limit ??