Dose anyone know how to do this

Hi jlw,
Your code must be like this now:

mysql_select_db($database_yourconnect, $yourconnect);
$query_carList = "SELECT * FROM cars";
$carList = mysql_query($query_carList, $yourconnect) or die(mysql_error());
$row_carList = mysql_fetch_assoc($carList);
$totalRows_carList = mysql_num_rows($carList);

Than in code view;
Write these before your query;

swtich ($_GET['order']){
case 'date':
$order = "date";
break;
case 'expiredate':
$order = "expiredate":
break;
default:
$order = "id";
}

and in your sql query add this: Order by '$order'

So finally you will have this:

swtich ($_GET['order']){
case 'date':
$order = "date".$_GET['sort'];
break;
case 'expiredate':
$order = "expiredate".$_GET['sort'];
break;
default:
$order = "id".$_GET['sort'];
}
mysql_select_db($database_yourconnect, $yourconnect);
$query_carList = "SELECT * FROM cars ORDER BY '$order'";
$carList = mysql_query($query_carList, $yourconnect) or die(mysql_error());
$row_carList = mysql_fetch_assoc($carList);
$totalRows_carList = mysql_num_rows($carList);

Your links will be like this:
Order By Date:
<a href="resultspage.php?order=date&sort=asc">Ascending</a>
<a href="resultspage.php?order=date&sort=desc">Descending</a>

Order by Expire:
<a href="resultspage.php?order=expiredate&sort=asc">Ascending</a>
<a href="resultspage.php?order=expiredate&sort=desc">Descending</a>

Change your variable names with the example codes. If you will use form to retrieve results use $_POST instead $_GET