PROTECTED]]
Sent: Saturday, February 17, 2001 03:12
To: ..s.c.o.t.t..; Php-General
Subject: RE: [PHP] Can I select only the newest record?
I wonder, if LAST_INSERT_ID will work in here...
I know it works when on the same file was an insertion.. but will it return
you the last ever inserted
select only the newest record?
On Saturday 17 February 2001 12:12, PHPBeginner.com wrote:
I wonder, if LAST_INSERT_ID will work in here...
I know it works when on the same file was an insertion.. but will it
return you the last ever inserted id, say a week ago?
It will you return the id
-General
Subject: Re: [PHP] Can I select only the newest record?
This worked:
SELECT * from that_table ORDER BY thetimestamp DESC LIMIT 1
Thanks to all for the help.
Brian Drexler
- Original Message -
From: Christian Reiniger [EMAIL PROTECTED]
To: Php-General [EMAIL PROTECTED]
Sent
On Saturday 17 February 2001 12:12, PHPBeginner.com wrote:
I wonder, if LAST_INSERT_ID will work in here...
I know it works when on the same file was an insertion.. but will it
return you the last ever inserted id, say a week ago?
It will you return the id that was used on the last INSERT
Using PHP3/MySQL, is there a way I can select only the newest record from a
MySQL table. I have a datetime field and an Auto_incremented field. Anyone
got any ideas???
Brian Drexler
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
it,
but this is what came to mind at the moment...
-Original Message-
From: Brian Drexler [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 20:22
To: Php-General
Subject: [PHP] Can I select only the newest record?
Using PHP3/MySQL, is there a way I can select only the newest record
6 matches
Mail list logo