doubingjiu3199
doubingjiu3199
2012-06-19 23:18

用于获取表中最后一行的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();
?>     
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

3条回答

  • dpwdldgn43486 dpwdldgn43486 9年前
    $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.

    点赞 评论 复制链接分享
  • dpo69086 dpo69086 9年前

    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()
    
    点赞 评论 复制链接分享
  • dongyata3336 dongyata3336 9年前

    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];
    
    点赞 评论 复制链接分享