Fifield, Mike wrote:
>I have a table with around 150 entries in it. I am querying the table with
>the fallowing command.
>SELECT * FROM guestbook LIMIT 140,9
>This is working fine I am getting the last 9 entries but I would like it to
>return them in reverse order. Is there a way to do this? I tried this
> SELECT * FROM guestbook order by id desc LIMIT 140,9
>But then I get the first 9 entries not the last 9 in reverse order, any help
>would be much appreciated.
>
SELECT * FROM guestbook order by id desc LIMIT 9
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php