<?php
 
$selected = array();
 
$orderby = $_GET[orderby];
if(!$orderby) { $orderby = 'price_asc'; }
 
if($orderby == 'price_asc') 
{
    $orderby_query = "order by price asc";
}
else if($orderby == 'price_desc')
{
	$orderby_query = "order by price desc";
}
else if($orderby == 'name')
{
	$orderby_query = "order by name";
}
else { unset($orderby); }
 
// If $orderby was valid set the selected sort option for the form.
 
if($orderby)
{
	$selected[$orderby] = 'selected';
}
 
// Now run your SQL query with the $orderby_query variable.  Ex:
 
$query = "select * from products $orderby_query";
 
// SQL code goes here..
 
?>
 
Sort by
<form method=get style="display: inline;" name='orderby_form'>
<input type=hidden name='param1' value="<?php print $param1; ?>">
<input type=hidden name='param2' value="<?php print $param2; ?>">
<select name=orderby onChange="orderby_form.submit();">
<option value='name' <?php print $selected[$orderby]; ?>>Name</option>
<option value='price_asc' <?php print $selected[$orderby]; ?>>Price (Low - High)</option>
<option value='price_desc' <?php print $selected[$orderby]; ?>>Price (High - Low)</option>
</select>
</form>
 

Commenting Options