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.
--------------------------------------------------------------------- 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