jaxdevil Posted August 1, 2008 Share Posted August 1, 2008 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" Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.