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

Question

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();
?>     

Answer 1

$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.