RE: [PHP] Want to exclude first 10 records from table

Thanks to all who responded to my qry, yes it worked well as per my requirements regards Manisha -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Want to exclude first 10 records from table

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:

Re: [PHP] Want to exclude first 10 records from table

On Wednesday 16 October 2002 14:44, Manisha wrote: > 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 exclu