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:[EMAIL PROTECTED]] 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>"; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
