[SOLVED] Multi ORDER BY Query

[TRI0N]

Okay I looked at the MySQL manuel for this and tried to sort some info by two keys..

 

$result4 = mysql_query("SELECT * FROM leaderboard WHERE (eventid = '$eventid') ORDER BY rounds_comp ASC, ORDER BY gross_score ASC LIMIT 10") ;

 

I bet it something so simple and dumb that I'll get hit in the head from behind.

 

MySQL site says to seperate them by a , but that doesn't seem to do the trick at all and neither do just a space.

 

[CrazeD]

Try this:

 

$result4 = 'SELECT * FROM leaderboard WHERE eventid ORDER BY rounds_comp ASC, ORDER BY gross_score ASC LIMIT 10';

[TRI0N]

Nope that didn't do the trick..   Bummage...

[monk.e.boy]

Try this:

 

$result4 = 'SELECT * FROM leaderboard WHERE eventid ORDER BY rounds_comp ASC, gross_score ASC LIMIT 10';

 

[monk.e.boy]

$result4 = 'SELECT * FROM leaderboard WHERE eventid ORDER BY rounds_comp ASC, gross_score ASC LIMIT 10';

 

Oooops, does the 'WHERE evenid' bit work, should this read:

 

SELECT * FROM leaderboard WHERE eventid=1 ORDER BY rounds_comp ASC, gross_score ASC LIMIT 10

 

monk.e.boy

[TRI0N]

Okay figured it out..  The correct format is:

 

$result4 = mysql_query("SELECT * FROM leaderboard WHERE eventid = '$eventid' ORDER BY rounds_comp DESC, gross_score ASC LIMIT 10") ;