RE: [PHP] Getting the last record in a mysql table
| From: | Niklas Lampén | Date: | Fri, 18 Jan 2002 06:29:37 +0000 |
| Subject: | RE: [PHP] Getting the last record in a mysql table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-81036@lists.php.net to get a copy of this message | ||
If you have ID that is a incrementing number, you could just query like
this:
'SELECT ID FROM MY_TABLE ORDER BY ID DESC, LIMIT 1'
And there you have just one result, the last (biggest) ID number.
Niklas
-----Original Message-----
From: hugh danaher [mailto:hdanaher@earthlink.net]
Sent: 18. tammikuuta 2002 7:37
To: Php-General
Subject: [PHP] Getting the last record in a mysql table
Help!
I thought this would be easy but it ain't. What I want is the id number
of the last record in a table. I've tried a number of variations to the
following but am getting no where! Any help will be greatly
appreciated. Hugh
$results=mysql_query(" SELECT last_insert_id() FROM MY_TABLE ");
$row=mysql_fetch_assoc($results); while
($row=mysql_fetch_row($results))
{
print "<tr>";
foreach($row as $field)
{
if ($field=="")
{
$field=" ";
}
print "<td align=center><h5>".$field."</h5></td>";
}
print "</tr>";
}
print "</table></td></tr></table>";