I forgot to add DESC for the ORDER BY clause:
........... ORDER BY SortedColumn DESC LIMIT 1
Thanks
Emery
----- Original Message -----
From: "Director General: NEFACOMP" <dg@nefacomp.net>
To: <nzegarra@kolareal.net>; <php-db@lists.php.net>
Sent: Sunday, September 28, 2003 19:05
Subject: Re: mysql, finding the last record
> 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: 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
> >
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
