Help Sql Query

[Critico]

why it does not work?

local query = db.getResult("SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = 7845 ORDER BY cast(value as INTEGER) DESC;")

 

[dgprado]

this depends on how this line is used in the lua script.

This is the real query:

SELECT `player_id`, `value` FROM `player_storage` WHERE `key` = 7845 ORDER BY cast(value as INTEGER) DESC;

This is LUA i think:

local query = db.getResult("   ")

Edited:

#1064 - 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 'INTEGER) DESC LIMIT 0, 30' at line 1

 

[Critico]

hm thanks... but it was simple:


ORDER BY cast(value as INTEGER)

to

ORDER BY cast(value as SIGNED)

solved

thanks