Quote:
|
Originally Posted by robbydweb
I have a mysql database of entries with one column having a number value called score.
is there sql command or a way to take the top 5 scores from the database and display them into an array?
|
"select value, score from table order by score desc limit 0,4"
try the above. i am not very good with asc or desc, so you might need to switch it. Also, 0,4 should show 5 entries... Also, replace value & score & table with the correct information for your sql table.
