Pulling pulling records from database

[wmhop]

I want to pull records from a database but only show 5 to 10 records at a time with the option of clicking a link to take you to the next 5 to 10 records. I've learned how to query the database for the records and display them but I don't know how to limit the number displayed and still be able to grab the rest of the records in case a person wants to continue to browse the records.

Anyone know how to do this?

[batman]

Here is a code that I use. It may need some editing.

// limit value for number of records to be shown per page 
// query database to find total number of records to display 
$limit = 5; 
$query_count = "select * from table"; 
$result_count = mysql_query($query_count); 
$totalrows = mysql_num_rows($result_count); 
if(empty($page)) 
$page = 1; 
$limitvalue = $page * $limit - ($limit); 
$query = "select * from tablek LIMIT $limitvalue, $limit "; 
$result = mysql_query($query) or die("Error: " . mysql_error()); 
$count_result = mysql_num_rows($result); 

// Display links at the top to indicate current page and number of pages displayed
$numofpages = ceil($totalrows / $limit);
echo"<br><p><b>$totalrows</b>matches found!</p>";
$from=$limit*$page-$limit+1;
$to=$from + $count_result-1;

// start 123 next>> table
echo "<table align=\"center\" width=\"90%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
            <tr><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"left\">";if($numofpages>1){echo"Showing: $from - $to</td><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"right\"><b>Go to page:</b> ";} 

// display previous link if page is not 1
if($page != 1){ 
$pageprev = $page - 1; 
echo("<a href=\"$PHP_SELF?page=$pageprev&search=$search\"><< PREV</a>&nbsp;"); 
} 

// display page nos if not 1 
for($i = 1; $i <= $numofpages; $i++){ 
if($numofpages>1){
if($i == $page) 
echo("&nbsp;".$i."&nbsp;"); 
else
echo("&nbsp;<a href=\"$PHP_SELF?page=$i&search=$search\">$i</a>&nbsp;"); 
}}

// display next page link if there is more than one
if(($totalrows - ($limit * $page)) > 0){ 
$pagenext = $page + 1; 
echo("<a href=\"$PHP_SELF?page=$pagenext&search=$search\">NEXT >></a>"); 
}
// end 123 next>> table
echo"</td></tr></table><br>";

Hope that helps at all,
-Blake

[wmhop]

In the following code:

$query = "select * from tablek LIMIT $limitvalue, $limit ";

What do the vaules for $limitvalue and $limit modify?

[batman]

What that's doing is doing a database search, but only retrieving the specific value you gave $limit.

$limit = 5;

Change the 5 to however many results you want to show per page.

-Blake

[wmhop]

I'm fairly new at using php and I've never seen an if-statement that was not bracketed as in:

if(empty($page))
$page = 1;
$limitvalue = $page $limit - ($limit);
$query = "select from tablek LIMIT $limitvalue, $limit ";
$result = mysql_query($query) or die("Error: " . mysql_error());
$count_result = mysql_num_rows($result);

Was that done on purpose?

Also, at what point in this code would I put statements to print my records to the screen?

[batman]

I guess it doesn't need brackets, cause it works ok for me.
You can put your code to display the results after the
// end 123 next>> table
echo"</td></tr></table><br>";

-Blake

[BeastRider]

Here is a pagination example which includes google type links to other pages.

http://www.herbhost.com/phptest/searchscript.php

If this is what you are looking to do then the scripts for these test pages are in the pagination.txt file below.