$maxrow = 10;
if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page=1; };
$start_from = ($page-1) * $maxrow;
$maxRows_rec_all_product = $maxrow;
$query_rec_all_product = "SELECT * FROM product order by sort desc";
$query_limit_rec_all_product = sprintf("%s LIMIT %d, %d", $query_rec_all_product, $start_from, $maxRows_rec_all_product);
$rec_all_product = mysql_query($query_limit_rec_all_product) or die(mysql_error());
$row_rec_all_product = mysql_fetch_assoc($rec_all_product);
<?php
$sql = "SELECT COUNT(*) FROM product";
$rs_result = mysql_query($sql);
$row = mysql_fetch_row($rs_result);
$total_records = $row[0];
$total_pages = ceil($total_records / $maxrow);
for ($i=1; $i<=$total_pages; $i++) {
echo "<a align='center' class='nav-a2' href='index.php?page=".$i."'>".$i."</a> ";
};
?>