mysql table sort from url

[chucklarge]

Hello

I am creating a table from mysql data. I have the column headers setup as links and clicking those sorts the table with php, so its not a javascript sort.

here is an example of two links

http://www.elementlabs.net/rma_test-02.php?orderby=compname&direction=ASC

http://www.elementlabs.net/rma_test-02.php?orderby=compname&direction=DESC

I was wondering what people do to remember what sort state was selected and put the opposite ASC or DESC link.

Basically if i am sorting by company name ASC, the company name header link should be DESC. I hope that makes sense.

I guess i could store it in a session variable, but was just wondering if there are other ways to do it.

thanks,
Chuck

[Drakla]

You could propage all states through the url link, messy but loads do it, or use a cookie, similar to the session solve.