Re: mysql, finding the last record
| From: | Joe Nilson Zegarra Galvez | Date: | Fri, 26 Sep 2003 17:38:48 +0000 |
| Subject: | Re: mysql, finding the last record | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30715@lists.php.net to get a copy of this message | ||
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