Question About Table Sorting

skymark · Post by **skymark** » Sat May 17, 2014 12:27 am

Hi all,

When we sort by a column header, the choice is remembered too long. Is there a way to go back to default order every time we enter a page.

More question: Is there a way to sort a text field like A1, A2, A10, not A1, A10, A2 ?

danielc · Post by **danielc** » Sat May 17, 2014 10:28 am

To set querystring for your page, this will set as your default order regardless of session value:
xxx.php?order=<field>&ordertype=ASC

For your second case, you may consider to change your table structure as this is default behavior. Or google "how can i sort a1 a2 a3 b1 b2 b3 aa1 aa2 aa3 in mysql".