mysql order by

[pjleonhardt]

I understand how to do an orderyby command in my sql query, but how would you go about doing a secondary order by?

i.e.
I want to order 'news updates' by their id.. in reverse order so the newest ones come first.. but, i would also like the more important ones to come first... so itd actually go sort by priority, and then within the priority groups, order it by reverse id..

so itd look something like...
$query = ("Select * from news ORDER BY priority AND ORDER BY id DESC");

???????????????????????

[LordShryku]

$query = ("Select * from news ORDER BY priority, id DESC");

[pjleonhardt]

ah, tyvm 🙂