Re: mysql, finding the last record
| From: | Director General: NEFACOMP | Date: | Sun, 28 Sep 2003 17:05:46 +0000 |
| Subject: | Re: mysql, finding the last record | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30739@lists.php.net to get a copy of this message | ||
For the last Auto-increment
SELECT LAST_INSERT_ID() FROM tblName;
For the last row data:
SELECT col1, col2, col3, col4 FROM tblName ORDER BY SortedColumn
LIMIT 1
I don't know what you are looking for exactly.
Explain and we will try to help though I am not an expert.
Thanks
Emery
----- Original Message -----
From: "Joe Nilson Zegarra Galvez" <nzegarra@kolareal.net>
To: <php-db@lists.php.net>
Sent: Friday, September 26, 2003 19:38
Subject: Re: [PHP-DB] mysql, finding the last record
> if you are seeking for the last in autoincrement field, in your select use
> this:
>
> select max(field) from table;
>
> if is other, well, i dont remember :D
>
> Regards
>
> Nilson
>
> John Ryan dijo:
> > is there any quick way of selecting the 'last' row in a mysql table?? i
> > could write some messy code but id prefer an elegant solution.
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> -------------------------
> Joe Nilson Zegarra Galvez
> Sistemas Kola Real
> Telefax : 0051-54-256658
> Movil: 0051-54-9603244
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>