MySQL newer entries? HELP

Anon

How would I display the newer entries to this guestbook I wrote on the top not the bottom. Here is the code:

$connection = mysql_connect (\"localhost\", \"root\", \"password\");
if ($connection == false){
echo mysql_errno().\": \".mysql_error().\" \";
exit;
}

$query = \"select * from guestbook\";
$result = mysql_db_query (\"koolplace_com\", $query);

if ($result){
echo \"\n<body bgcolor=\\"#004080\\" text=\\"#FFFFFF\\" link=\\"#FFCC00\\" alink=\\"#FFCC00\\" vlink=\\"#FFCC00\\">\n\";
echo \"<table border=\\"0\\" cellspacing=\\"3\\" cellpadding=\\"0\\" width=\\"400\\" align=\\"center\\">\n\";
$numOfRows = mysql_num_rows ($result);
for ($i = 0; $i < $numOfRows; $i++){

$name = mysql_result ($result, $i, \"name\");
$email = mysql_result ($result, $i, \"email\");
$url = mysql_result ($result, $i, \"url\");
$title = mysql_result ($result, $i, \"title\");
$refer = mysql_result ($result, $i, \"refer\");
$location = mysql_result ($result, $i, \"location\");
$opinion = mysql_result ($result, $i, \"opinion\");
$date = mysql_result ($result, $i, \"date\");
$comments = mysql_result ($result, $i, \"comments\");
echo \"<tr>\n\";
echo \"<td height=\\"5\\" bgcolor=\\"#0063A4\\"> ••</td>\n\";
echo \"</tr>\n\";
echo \"<tr>\n\";
echo \"<td> : Name : <a href=\\"mailto:$email\\">$name</a></td>\n\";
echo \"</tr>\n\";
echo \"<tr>\n\";
echo \"<td> : Homepage : <a href=\\"$url\\" target=\\"_blank\\">$title</a></td>\n\";
echo \"</tr>\n\";
echo \"<tr>\n\";
echo \"<td> : Referred by : $refer</td>\n\";
echo \"</tr>\n\";
echo \"<tr>\n\";
echo \"<td> : Location : $location</td>\n\";
echo \"</tr>\n\";
echo \"<tr>\n\";

echo \"<td> : Rating : $opinion</td>\n\";
echo \"</tr>\n\";
echo \"<tr>\n\";
echo \"<td> : Date : $date</td>\n\";
echo \"</tr>\n\";
echo \"<tr>\n\";
echo \"<td height=\\"5\\"></td>\n\";
echo \"</tr>\n\";
echo \"<tr>\n\";
echo \"<td width=\\"100\\" valign=\\"top\\"> : Comments :</td>\n\";
echo \"</tr>\n\";
echo \"<tr>\n\";
echo \"<td>$comments</td>\n\";
echo \"</tr>\n\";
echo \"<tr>\n\";
echo \"<td height=\\"25\\"> </td>\n\";
echo \"</tr>\n\";
}

echo \"</table>\n\";
echo \"</body>\n\";
echo \"\n\";
}
else{
echo mysql_errno().\": \".mysql_error().\" \";
}

mysql_close ();

Anon

This board has seemed to mess up the code you can view it here.

http://www.koolplace.com/gbook.phps

Anon

$query = "select * from guestbook ORDER by date DESC";

Anon

Don't forget

LIMIT n

if you only want to see the newest n entries.

Anon

Thanks Louie and Kirk for your help. It is really appreciated.