PHP 根据添加日期将 2 最后一行数据显示到最后一行 HTML 表 - PHP Display 2 Last Row data to Last Row HTML table based on Date Added

PHP Display 2 Last Row data to Last Row HTML table based on Date Added

<table>
<td>ID</td>
<td>Name</td>
<td>Date Added</td>
<tr>
<?php
$q = mysql_query("SELECT * FROM tab ORDER BY date_added DESC LIMIT 2");
while($d = mysql_fetch_array($q))
{
echo "<td>$d['id'];</td>";
echo "<td>$d['name'];</td>";
echo "<td>$d['date_added'];</td>";
echo "<tr>";
}

例如，我有 4 个数据。我想根据 DESC 获取 2 date_added最后一行并将其显示在最后一行 HTML 表 td 中。

请帮忙。

试试这个

<table>
<tr>
<td>ID</td>
<td>Name</td>
<td>Date Added</td>
</tr>
<?php
$q = mysql_query("SELECT id,name,date_added FROM table ORDER BY  date_added DESC LIMIT 2");
while($d = mysql_fetch_array($q))
{
echo "<tr><td>".$d['id']."</td>";
echo "<td>".$d['name']."</td>";
echo "<td>".$d['date_added']."</td>";
echo "<tr>";
}
?>
</table>