$pageNumber = (empty($pageNumber))?0:$pageNumber;
$rowPerPage = (empty($rowPerPage))?10:$rowPerPage;
$sqlCount = "SELECT * FROM ten_bang ... "; // thay doi cau lenh cho phu hop
$totalRows = mysql_num_rows(mysql_query($sqlCount)) or die(mysql_error());
$totalPages = $totalRows/$rowPerPage;
if(($totalRows % $rowPerPage) >0)
$totalPages ++;
//tự động load toàn bộ theo từng trang
$pageLoaded = 0;
while($pageLoaded <$totalPages){
// Nếu chỉ load 1 trang thì bỏ vòng lặp đi,
$sqlLoadPage = "SELECT * FROM `data` LIMIT {$pageNumber}*{$rowPerPage},{$rowPerPage} ";
$result =mysql_query($sqlLoadPage) or die(mysql_error());
while ( $row = mysql_fetch_array($result))
{
}
}
// dùng cho in ra số trang
//for ( $page = 0; $page <= $totalPages; $page ++ )
//{
//echo "<a href='index.php?page={$page}'>{$page}</a>";
//}