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 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.
Use LIMIT -- rtfm for the database you're using for details. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* It's not hard to admit errors that are [only] cosmetically wrong. -- J.K. Galbraith */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php