hi look into LIMIT http://www.mysql.com/doc/en/SELECT.html select .....as before LIMIT 11,999 or something similar Peter -----Original Message----- From: Jason Wong [mailto:php-db@gremlins.biz] Sent: 30 April 2003 11:00 To: php-db@lists.php.net Subject: Re: MySQL select query problem On Wednesday 30 April 2003 17:55, Davy Obdam wrote: > I have a newssection on my website, and on the first page i am selecting > the first 10 items. Well thats easy... Now i want to build a page with > the rest of the newsitems, wich shouldnt include the first 10 already > displayed on the main news page. How could i select everything, except > the first 10 items. Thanks already;-) How are you selecting the first 10 items? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* A Law of Computer Programming: Make it possible for programmers to write in English and you will find that programmers cannot write in English. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
