[SOLVED] Sorting table results

[soycharliente]

I tried searching Google for some stuff about sorting table results.

I want to be able to click the different headers and sort the results by each field.

 

Anyone know some good sites/tutorials?

[lemmin]

Assuming you are using MySQL, here is the documentation for it. http://dev.mysql.com/doc/refman/5.1/en/order-by-optimization.html

[soycharliente]

I was looking more for how to set up the links/code so that it will sort ASC each field when you click on it (and DESC if clicked again).

[lemmin]

That is a little bit trickier. I don't have my code here, but the way I did it (if I remember correctly) was with a GET variable that told whether it was asc or desc. To dynamically change the query, all you have to do is something like this:

$query = "SELECT * FROM table";
if ($_GET['var'] == "asc")
   $query .= " ORDER BY DESC";

[soycharliente]

And should I just assume that the user won't mess with what the URL is and not care about people typing in random smut in the URL?

[dbo]

Of course not. It was an example.

[lemmin]

With my code I posted, nothing malicious could be done with typing anything into the URL. It simply checks if the var IS asc, it doesn't use that value in the query.