Switch sort from ASC to DESC

[aaron_karp]

Hi - I'm building a pretty standard table that displays the information for the users in a databse. The leftmost colums holds their email address, next holds an interger value, and so it goes.

Above each column I have some small text describing what's below it, i.e. "Email Address" then "Amount" and so it goes.

What I want to do is pretty much what you see all over the place. When the user clicks on that text link, I want it to reload the page except with the table sorted by that category. I can acomplish this. My problem is how to get it to switch to descending when the user clicks on that link again. Any suggestions?

[khaldryck]

when you load a page, you can know what order you are using ...
all you have to do is change the link of this text to desc instead of asc.

ex :

let's give an exemple :

you have a page called display, it can show names and emails in order either ASC or desc

links should be :
display.php?orderby=name&orderasc=asc
display.php?orderby=email&orderasc=desc

just test :
use this code for each place you need to put asc or desc in the a href.
if($orderby==email) {
if($orderasc=='asc') echo "desc";
else echo "asc";
}

i hope it's clear enough.

[aaron_karp]

Can i actually put that if statement right in the middle of the SELECT query?

[khaldryck]

just do something like that :

$query="Select name, email from users where where_conditions
order by $orderby $orderasc";

that way your query will work exactly what you want.

the if() must be in the page where you create your links a href, not in your query.