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:[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]
