Niklas,
I needed to change the statement slightly, but it did put me on the right
track.
Thanks again,
Hugh
$result=mysql_query("SELECT id FROM my_table ORDER BY id DESC, id limit 1");
$id=mysql_result($result,0);
----- Original Message -----
From: Niklas Lamp�n <[EMAIL PROTECTED]>
To: Php-General <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 10:29 PM
Subject: RE: [PHP] Getting the last record in a mysql table
> 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]
>
--
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]
