22.05.2014, 03:12
Is there a way to select or sort data from a query and ensure it's greater then a specified integer? Such as...
I'm trying to retrieve data, but I'd like it to only retrieve entries from the database that are greater then 0. Thanks.
pawn Код:
new DBResult:result;
result = db_query(database, "SELECT `VALUE` FROM `TABLE` ORDER BY (`VALUE` * 1) WHERE `VALUE` > `0`");
db_free_result(result);