用于获取表中最后一行的SQL语句

I have a table - xxxx_nb_lo_update_date - with a number of columns and rows that are ordered by the variable id. I need to get the last entry in the table, and I've been having trouble with this.the code is not producing any thinng when run .. the content to be displayed is a timestamp ..

<?php
   $link = mysql_connect('www.xxxxxxx.co.uk', 'xxxxx', 'axxxxxx');
   if (!$link) {
       die('Could not connect: ' . mysql_error());
   }
   mysql_select_db("xxxxxxx", $link);

   $numrow122 = mysql_query("SELECT TOP 1 last_lo_update_date FROM xxxx_nb_lo_update_date  ORDER BY id DESC "); 

   echo "<font color='blue'>$numrow122</font>";
   mysql_close();
?>     

$numrow122 = mysql_query("SELECT last_lo_update_date FROM xxxx_nb_lo_update_date ORDER BY id DESC LIMIT 1"); 

echo "<font color='blue'>" . mysql_result($numrow122, 0, 0) . "</font>";

That should get you the exact field you want.

you should not rely on an autoincremented primary key to establish chronology

that aside, you need to fetch the row

$ds = mysql_query("SELECT last_lo_update_date FROM xxxx_nb_lo_update_date ORDER BY id DESC limit 1"); 
$rs = mysql_fetch_array ($rs);

print $rs[0];

If your id is an AUTO_INCREMENT column can use the function:

LAST_INSERT_ID()

SELECT last_lo_update_date FROM xxxx_nb_lo_update_date WHERE yourId = LAST_INSERT_ID()