mysql last rows_如何获取Mysql数据库表中的最后十行？(How can I get the last ten rows in a Mysql database table?)...

如何获取Mysql数据库表中的最后十行？(How can I get the last ten rows in a Mysql database table?)

我用这个

$query = "SELECT * FROM info ORDER BY id DESC limit 10";

$result = @mysql_query( $query );

$row = mysql_fetch_array($result);

print_r($row);

但它只是最后一排

I use this

$query = "SELECT * FROM info ORDER BY id DESC limit 10";

$result = @mysql_query( $query );

$row = mysql_fetch_array($result);

print_r($row);

but it gets just the last row

原文：https://stackoverflow.com/questions/1138588

更新时间：2020-02-05 04:16

最满意答案

它从一行中获取一列列。

要获取所有行，您必须在循环中运行它：

$query = "SELECT * FROM info ORDER BY id DESC limit 10";

$result = @mysql_query( $query );

while ($row = mysql_fetch_array($result))

print_r($row