[Resolved] Order By 3,2,1

As a general question, how do you do an ORDER BY
based on a column values. I want to show in the following order on a table:

Mpln '3' 1st
Mpln '2' 2nd
Mpln '1' 3rd

-maybe not any Mpln "0"'s but could just as well exlude these
with an If/Else statement on the page.

Well, if you're grabbing from a database:

"SELECT * FROM table ORDER BY column_name DESC"

Column name would be the column that holds the 3,2,1 value(s) and the DESC would order it descending. You can also use ASC to sort it ascending.

~Brett

thanks bpat1434