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]>,
Subject: Re: [PHP-DB] Math and mySQL
Date: Fri, 3
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]>;
Sent: Thursday, December 30, 2004 10:53 AM
Subject: RE: [PHP-DB] Math and mySQL
> see intersp
see intersperesed comments
bastien
From: "Ron Piggott" <[EMAIL PROTECTED]>
To: "PHP DB"
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?
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 the SELECT command and just for
example the field I know could be serial_number = 30612312-ABDEFG --- I have
the serial_number field set as a varchar.
Part two of my question is how