Sorting results from sql query by clicking a button

[jond]

Hi, I want to be able to sort a a list of images by clicking a button. I understand how to sort them with an sql query like this.

 

$query = mysql_query("SELECT * FROM images ORDER BY date DESC LIMIT $offset, $rowsPerPage",$con);

 

but how would I have two buttons so that the user could switch between descending and ascending? I've been trying submit buttons with if statements containing the sql query but I'm not having any luck.

 

Thanks for any help 

[marklarah]

$order = (if button one was selected) ? "DESC" : "ASC";
$query = mysql_query("SELECT * FROM images ORDER BY date $order LIMIT $offset, $rowsPerPage",$con);

 

Something like that? I'm not sure...