retrieve most recent row from mysql database

Can someone point me to a tutorial that will show me how to display the most recent row from a mysql database table?

I already have a page that paginates results from a table, but I would like to display the most recent entry from each table on the front page of my site.

Thanks

edit: I have an ascending field "id" that is the primary key.

 

That depends on the structure of your table. If you have an autoincrement ID, which for the sake of argument we'll assume you called "Id" then...

Select * from <table> where <blah blah blah> order by Id DESC

Or, perhaps you have a timestamp column when the record was created...

Select * from <table> where <blah blah blah> order by TimeStamp DESC


But you get the idea.... ORDER BY <column> DESC

 

Remember the LIMIT 1 (no use fetching all rows when you only need one )

SELECT * FROM table ORDER BY id DESC LIMIT 1

Code (markup):

 

WOW! Am I noob when it comes to MySQL!

This took forever.
I had to use this:

$rs = $db->Execute( $sql );

Code (markup):

So I used

<?
$sql = "SELECT * FROM entries ORDER BY id DESC LIMIT 1";
$rs = $db->Execute( $sql );
?>

Code (markup):

But then I had to display what I just called so I used this:

		  <h2><?=$rs->fields['title']?></h2>
<?=$rs->fields['thumbnail']?>

Code (markup):

I know this is elementary stuff but it took me all morning to figure out. I am posting this so anyone in the future who searches for it will have a comprehensive answer.

+green for everyone who replied

Thanks