How do I set the order by 2 entries?

Paragon

I want to do Order BY id and dlevel

How can I do this?

drawmack

the same way as the person who asked this question yesterday.

OhLordy

ORDER BY id, dlevel will order by id and then where the id's are the same order by dlevel
HTH
Rob

vaska

howabout - ORDER BY id DESC ORDER BY dlevel ASC

ascending and descending...maybe you need a comma between desc and order...maybe not...

good luck!

Paragon

How about numbers before letters?

nightowl

Don't think that this is valid SQL ... you cannot have 2 "order by" clauses ...

"order by field1 desc, field2 asc."

Originally posted by vaska
howabout - ORDER BY id DESC ORDER BY dlevel ASC

ascending and descending...maybe you need a comma between desc and order...maybe not...

good luck!