You can use LIMIT clause: SELECT fields FROM table LIMIT X,25
where X is number of row to start with. You can substitute this number for example in HREF: <A HREF="?X=25">Page2</a> <A HREF="?X=50">Page3</a> <A HREF="?X=75">Page4</a> then your script should take X value and use it to compose the query. Aqua wrote: > I have 100 records in mySQL database and I need to display them in my web > page using php and html. How to display them in multiple pages? Each page > must contain 25 records. Does anyone know how to do it other than create 4 > pages and manually list the records there? or maybe point me some reference > please. Your help will be much appreciated. Thanks! > > Aqua > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Barkov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia <___/ www.mysql.com +7-902-856-80-21 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php