Hi, i have problems to get the top 10values from a SQLite database.
The first code gives me the values but I want it to be sorted like from the richest players to the poorest players with a limit of 10 player.
Example.
1. 1,901,011$
2. 1,871,110$
3. 1,681,191$
etc.
1. code
function getData( )
return dbPoll ( dbQuery ( db, "SELECT * From (Select * from data ORDER BY money desc) LIMIT 10 " ), -1 )
end
setTimer(getData, 5000, 0)
This is how this code returns: