php - SELECT FROM 表 WHERE lastupdated = 最近更新

Question

如何从表中选择最近更新的行。我的语法似乎有问题。

<?php 
require_once 'db_conx.php';
$Result = mysql_query("SELECT * FROM  'table' WHERE lastupdated('timestamp') = CURDATE()")      or die (mysql_error());
while($row = mysql_fetch_array($Result))
{
echo $row['name'] . "" .$row['phoneno'];
}
mysql_close($con);
?>

Answer 1

如果您需要最后更新的最新记录，那么您可以试试这个::

SELECT * FROM  'table' order by lastupdated desc limit 1