yes, that will work... however, if you're trying to select from
a table that lacks an explicit AUTO_INSERT field, yet has an
incrementing field (DATETIME is one that comes to mind),
selecting the LAST_INSERT_ID wouldnt work...
> -----Original Message-----
> From: PHPBeginner.com [mailto:[EMAIL 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 id, say a week ago?
>
> I feel like it won't, but don't know for sure... try it...
>
>
> Sincerely,
>
> Maxim Maletsky
> Founder, Chief Developer
>
> PHPBeginner.com (Where PHP Begins)
> [EMAIL PROTECTED]
> www.phpbeginner.com
>
>
>
>
>
>
> -----Original Message-----
> From: ..s.c.o.t.t.. [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 17, 2001 4:59 PM
> To: Php-General
> Subject: RE: [PHP] Can I select only the newest record?
>
>
> there are two ways that come to mind of doing this if you're
> using some kind of auto-incrementing field (not necessarily
> AUTO_INCREMENT, but any field that increases [or decreases]
> with time)
>
> this will select the entire row, but limit the query to only
> return 1 result (and depending on how your order, this
> result could be the highest/lowest value of the field):
>
>
> (to get highest value of field id)
> SELECT * FROM mytable ORDER BY id ASC LIMIT 1;
>
> (to get lowest value of field id)
> SELECT * FROM mytable ORDER BY id DESC LIMIT 1;
>
>
> PS: there's probably a more efficient way to do 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 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 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]
>
--
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]
