Ordering results

[Anon]

Could anyone help me out? I need to know how to order scores from highest to lowest, the statement im using at the moment is;

else {
$result = mysql_query("SELECT * FROM coasters ORDER BY score LIMIT 10");
if ($details = mysql_fetch_array($result)) {

but this orders the scores from lowest to highest.

is it obvious im new to this 🙂

[Anon]

ORDER BY [fieldname] ASC or ORDER BY [fieldname] DESC

I'm pretty sure these are the proper statements.

http://www.w3schools.com/sql/default.asp

[we_win]

Reframe your sql statemet to the following

$result = mysql_query("SELECT * FROM coasters ORDER BY score desc LIMIT 10");

desc stands for descending order

Viv

[Anon]

Thanks a lot for your help guys!