Re: Getting the last record in a mysql table

Another option under same condition is: 'SELECT MAX(ID) AS LASTID FROM MY_TABLE' Alex Chau Niklas Lampén wrote:

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="&nbsp;"; } print "<td align=center><h5>".$field."</h5></td>"; } print "</tr>"; } print "</table></td></tr></table>";