Want to exclude first 10 records from table
| From: | Manisha | Date: | Wed, 16 Oct 2002 06:44:24 +0000 |
| Subject: | Want to exclude first 10 records from table | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-120118@lists.php.net to get a copy of this message | ||
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