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 excluding

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

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