This topic is locked

Sort the list-page different

2/28/2009 10:06:12 AM
PHPRunner General questions
M
macnoell author

I have several columns on my list page. I can't really see how all the items are sorted. I want to sort them by default on one column (Name) and then alphabetticaly. How do I dot that?

kujox 2/28/2009

I have several columns on my list page. I can't really see how all the items are sorted. I want to sort them by default on one column (Name) and then alphabetticaly. How do I dot that?


You need to edit the mysql query and just after the last line put
ORDER BY Name
you can then add other fields on to that seperated by a comma
ORDER BY Name,column2,column3