[SOLVED] Sorting a DISTINCT query by a column other than the distinct one?

[jaxdevil]

Ok, I don't know what I was thinking when I did this but here I am, so I need to find a solution.

 

I made a query to select the distinct rows, then I made a new field in the table (numerical) to sort the results. After I added the 'ORDER BY' to the end I realized how foolish that was. So what can I do to sort this query by a field other than the distinct one? Here is the query:

 

"$sql_make = "SELECT DISTINCT `cat` FROM cats_$region ORDER BY `sort` ASC"