php/mysql question

[Anon]

I'm trying to figure out how to query a db to display the newest entry. Basically I want the content on my page to display the newest record in the db. It could either go by date or the highest id# available.

If anyone can let me know how to do this or point me to resources with this info, that would be great.

Thanks a lot,
Shawn

[Anon]

<?php
// Input your connection to your database.

$query = "select max(id), message from entry limit 0, 100";
$result = mysql_query($query) or die("Error selecting newest message.");
while(list($id, $message) = mysql_fetch_row($result))
{
print("$id, $message");
/ The above variables holds both the id ($id) and the newest message($message) from the database. That is only if, the information is submitted in least to highest order where highest is the most recent. /
}

// Close the connection.
?>