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
|• ORDER||Mike Fifield||21 Aug|
| • Re: ORDER||Gerald Clark||21 Aug|