select * from forum order by postdate desc LIMIT 10, -1 Assuming you are using MySQL of course.
See the official documentation for further assistance: http://www.mysql.com/doc/en/SELECT.html -----Original Message----- From: Manisha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 16 October 2002 4:44 PM To: [EMAIL PROTECTED] Subject: [PHP] Want to exclude first 10 records from table I am having forum table. First 10 records are treated as Current postings and rest are treated as Archive. I know how to take first 10 select * from forum order by postdate desc LIMIT 10 But I do not know how to take postings excluding above 10. I do not want to make use of loop rather I want to do this in one single query as I need to pass this to some further include files. Thanks in advance Manisha -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
