Sorting ascending and descending at the same time

[mrgrammar]

$getco = "SELECT customerid, company FROM customers ORDER BY customertypeid, company";

I want the fields sorted descending by customertypeid then ascending by company.

How should the query be formed to achieve this?

Mr.Grammar

[AstroTeg]

I believe this should work:

SELECT customerid, company FROM customers ORDER BY customertypeid DESC, company ASC

[mrgrammar]

OMG! Duh! It's been a looooooong day. I knew that.