Looking For Some Help With Pagination.

[This_Is_Craig]

I've been reading through some tutorials on pagination, and I'm trying to implement it into a current project, but I'm not having the best luck with it. I already have some PHP pulling info from a database and everything how I'd like, so that's all set, but I'm not sure how to implement that into some PHP for pagination.

The PHP I have right now that I'd like to paginate is this:




<?PHP

$user_name = "####";
$password = "####";
$database = "####";
$server = "####";

$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);

?>
<div id="listing_top"></div>
<div id="listings">

<?PHP

if ($db_found) {

$SQL = "SELECT * FROM tbl_rest_list ORDER BY Name";
$result = mysql_query($SQL);

while ($db_field = mysql_fetch_array($result)) {

if(!empty($db_field['url'])) {
echo '<div class="name">' . "<h3>" . $html = '<a href="' . $db_field['url'] . '">' . $db_field['Name'] . '</a>' . "<h3>" . "</div>";
}
else {
echo "<div>" . "<h3>" . $html = $db_field['Name'] . "<h3>" . "</div>";
}

echo "<div>" . $db_field['Street'] . "</div>";

echo "<div>" . $db_field['City'] . ", " . $db_field['State'] . "</div>";

echo "<div>" . "<em>Phone: </em>" . "<strong>" . $db_field['Phone'] . "</strong>" . "</div>";

echo "<div>" . $db_field['Email'] . "</div>";

echo '<div id="type">' . "<em>Type of Food: </em>" . $db_field['Type'] . '</div>';
}
mysql_close($db_handle);

}
else {
echo "Database NOT Found ";
mysql_close($db_handle);
}
?>

</div>

<div id="listing_bottom"></div>



Thanks in advance for any help. You guys have already helped me a ton in understanding PHP. I really appreciate it.

[jpstokes]

I'm assuming that you have some sort of list that you'd like to page. The following query is what I use to do paging...


$displayNumber = 20;
$lowerBound = ($page_number - 1) * $displayNumber;
$sql = "select * from table_name limit $lowerBound, $displayNumber";

You'll need to set a page variable and increment/decrement this variable as you go from page to page. Then in your php you capture the page number and the code does the rest.

**note - $displayNumber = the number of items to show in your list.