[SOLVED] MySql Order by

[zackcez]

I'm just wondering how I can order by two fields

Explain:

I'm ordering by Level, there's two rows with the same 'Level', then if that happens I want it to order by 'exp'...Example:

Bob - Level: 1234 Exp: 432

Sue - Level: 1234 Exp: 1234

Tim - Level: 12 Exp: 5000

 

I would like it to have Sue ahead, then Bob, then Tim.

So basically I want it to first order by "level" if there's more than one row with the same thing, then order those by 'exp'

 

All help is appreciated,

Zack

[Ken2k7]

ORDER BY Level DESC, Exp ASC

Like that?