select MAX(id), * from tablename
you can also use a datetime field to select from as well, depends on your
data structure
bastien
From: Ron Piggott [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED], php-db@lists.php.net
Subject: Re: [PHP-DB] Math and mySQL
Date: Fri, 31 Dec 2004 20:53:10
Do you have the actual syntax for the SELECT command to retreive the last
record?
Ron
- Original Message -
From: Bastien Koert [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; php-db@lists.php.net
Sent: Thursday, December 30, 2004 10:53 AM
Subject: RE: [PHP-DB] Math and mySQL
see
see intersperesed comments
bastien
From: Ron Piggott [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Math and mySQL
Date: Thu, 30 Dec 2004 05:51:44 -0500
Is there any way of retreiving the last record of a mySQL table where I may
specify one of the values in it? I know