Same page must be loaded with different query

[aepstar]

Hello. I have this query:

$query1 = mysql_query("SELECT * FROM table1 ORDER BY first_name ASC");

this is when the page is loaded automatically. then there is a link above the table called name. i want that if u click on it the same page is loaded but instead it is ordered in DESC order. and vice versa if u click the same link again. Someone?

[LordShryku]

The link must have some sort of variable so the page knows how to sort. Append a sorter variable on it, and sort by that.

if(isset($_GET['sort']) && $_GET['sort'] == 1) {
   $way = "DESC"; // sort DESC
   $addUrl = NULL; // add mothing to the link
}
else {
   $way = "ASC"; // sort ASC
   $addUrl = "?sort=1"; // add sort to the link
}

$query1 = mysql_query("SELECT * FROM table1 ORDER BY first_name ".$way); 

// Then for the link
echo "<a href=\"".$_SERVER['PHP_SELF'].$addUrl."\">Sort ".$way."</a>";

Something like that....

[aepstar]

if i were god i would make u immortable 😃