Use LIMIT in your SQL query.
_____ From: php_mysql@yahoogroups.com [mailto:php_my...@yahoogroups.com] On Behalf Of zarilahr Sent: Friday, January 30, 2009 10:17 AM To: php_mysql@yahoogroups.com Subject: [php_mysql] paging in php Dear Sirs For example i have 3 categories like Mobiles, Laptops, Speakers. Against each catagory i have 100 pictures . i want when i click on mobiles it shows only 10 pictures on first page and show the paging at bottom of page like 1,2,3,4,5....and on page number 2 next 10 pictures and so on. Same like that i want to do with all other categories like laptos and speakers. Please guide me towards some tutorial, or send a code for paging. I will be very thankfull to you. Regards [Non-text portions of this message have been removed]
