MySQL sorting issue

[gizmicek]

hi all,
I have one question about MySQL sorting. I know this is PHP forum but almost all of you work also with MySQL so you can help me as well. The thing is that I have the user toplist on my pages which should be sorted by rank (integer value) and then by alphabetical order within one rank group. I would like to know if there is some MySQL query like "..ORDER BY `status` AND `login`" or something like that which would do the job. Otherwise I will have to do some cycle which will go through particular rank groups and will sort the users then by alphabet.

Any help would be appreciated.

Peter

 

[sleipnir214]

You can order by multiple columns.

Order by foo, bar desc

will sort the return by foo ascending then bar descending.

For more information:

http://www.mysql.com/doc/en/SELECT.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[gizmicek]

>sleipnir214
This does the job, thanx very much ;-)