How do I add a link to change sort order?

[bsanderson]

I have a php page that outputs a list sorted by a field in ascending order. In order to sort the output in descending order, I have a link to an identical page with DESC added to the end of the query. I would like to do this with a single page. How can I add a link to the page that would reload the page with a different query.

Any help will be greatly appreciated.

 

[spamjim]

You'd create links like...

http://www.yoursite.com/page.php?sort=A

for an ascending sort.

http://www.yoursite.com/page.php?sort=D

for a descending sort.

Then you'd process them on page.php with...

if ((isset($_GET['sort'])) AND ($_GET['sort'] == "A")) { $query = $query . " ORDER BY something ASC"; }
if ((isset($_GET['sort'])) AND ($_GET['sort'] == "D")) { $query = $query . " ORDER BY something DESC"; }

 

[bsanderson]

Works great. Thanks