[Resolved] SQL Sorting

[NZ_Kiwi]

I want to sort the $sql by $date... how would i add that to this line??

><?php 
include 'config.php'; 
//Check if the page number is defined else set it to one. Standard Procedure. :)
if(!isset($_GET['page'])){
	$page = 1;}
	else {$page = $_GET['page']; 
} 
//Calclate the offsets
$from = (($page * $max_results) - $max_results); 
// Creat the query to be performed and then perform it.
$sql = mysql_query("$query_list where trip_id = $trip_id LIMIT $from, $max_results");
// pre_result output
echo $pre_result;
while($row = mysql_fetch_array($sql)){ 
?>

[devinemke]

$sql = mysql_query("$query_list where trip_id = $trip_id ORDER BY date LIMIT $from, $max_results");