Re: ORDER

[Gerald Clark]

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