List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 21 2002 5:44pm
Subject:Re: ORDER
View as plain text  

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


Thread
ORDERMike Fifield21 Aug
  • Re: ORDERGerald Clark21 Aug