te dejo un ejemplo, pero lo tendras que implementar a tus medidas, saludos
Código PHP:
<?php
$result = mysql_query("SELECT COUNT(*) AS total_entries FROM products") or die(mysql_error()); $row = mysql_fetch_row($result); $total_entries = $row[0];
$entries_per_page = 3;
if(isset($_GET['page_number'])) { $page_number = $_GET['page_number']; } else { $page_number = 1; }
$total_pages = ceil($total_entries / $entries_per_page);
$offset = ($page_number - 1) * $entries_per_page;
$result = mysql_query("SELECT * FROM products LIMIT $offset, $entries_per_page") or die(mysql_error()); while($obj = mysql_fetch_object($result)) { // Display the data however you want here. print <<id - $obj->name - $obj->description<br>
or($i = 1; $i <= $total_pages; $i++) { if($i == $page_number) { print "$i "; } else { print " <a href="products.php?page_number=$i"><?$i;?></a> "; } }
?>