Calendar problem

ok this is a news calendar. All is going well so far with the code but i want to reverse the order that the records are displayed. So right now the newest items are on bottom and the older items are on top, i want to reverse that. Can someone help plz

<title>The Edge Homepage</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
.style1 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 7pt;
	color: #FFFFFF;
<link href="style.css" rel="stylesheet" type="text/css">
<body bgcolor="#1F7697" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" bottommargin="0">
<table border="0" cellpadding="0" cellspacing="0">

$query = "SELECT date, subject FROM Calendar"; 
$result = mysql_query($query) or die (mysql_error()); 
$num = mysql_num_rows($result);

if($num > 0){
while($row = mysql_fetch_array($result, MYSQL_NUM)){

echo"<tr><td><span class=\"style1\">$row[0]</span></td><td><span class=\"style1\"><a href=calendar2.php target=_parent>$row[1]</a></span></td></tr>";
echo'<span class="style1">The calendar is experiencing technical difficulties. We apologize for the inconvenience.</span>'; 


Change your SQL from

$query = “SELECT date, subject FROM Calendar”;


$query = “SELECT date, subject FROM Calendar ORDER BY date DESC”;

thanks man, ill try that;)


sweet it works thanks:)