order by twice?

[EchoFool]

Is it possible to order data in a primary way then a secondary way in the same query?

 

For example some thing like:

<?php
$Get = mysql_query("SELECT UserID,Title,Infomation,Allowed FROM staff ORDER BY StaffType ASC ORDER BY UserID DESC")
Or die(mysql_error());
?>

 

So you then would have the staff grouped by either admin/coder etc

followed by each group sorted by UserID like:

 

Admin:

User 2

User 1

Coder:

User 6

User 3

[AndyB]

Yes ... as long as you have the syntax right (which you don't) - http://www.w3schools.com/php/php_mysql_order_by.asp