PHP - how to page my result - Asked By Olusegun A. on 22-Sep-09 05:11 AM

Hello there, am designing a site that requires search and i need my result to display 10 results per page, please how do i go about designing the result-display page. thanks in advance.

regards,
olusegun

Paging with PHP - mv ark replied to Olusegun A. on 22-Sep-09 05:49 AM

These PHP scripts can get you started -
http://www.plus2net.com/php_tutorial/php_paging.php
http://www.web-max.ca/PHP/misc_1.php
http://webdevtips.co.uk/webdevtips/php/paging.php

re - Web Star replied to Olusegun A. on 22-Sep-09 06:10 AM

The key is pass the number from which the 10 records for every page needs to be retrieved.

[)ia6l0 iii replied to Olusegun A. on 22-Sep-09 10:29 AM
SELECT value FROM randoms LIMIT 0,10  would be a sample sql that returns 10 records from the zeroth record, so you would just change the the value '0' based on the page number that you hit.