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
<html>
<head>
<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;
}
</style>
</style>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#1F7697" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" bottommargin="0">
<table border="0" cellpadding="0" cellspacing="0">
<?php
require_once('mysql_connect.php');
$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>";
}
}
else
{
echo'<span class="style1">The calendar is experiencing technical difficulties. We apologize for the inconvenience.</span>';
}
echo'</table>';
mysql_free_result($result);
mysql_close();
?>
</span>
</table>
</body>
</html>