code phân trang bằng php

$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>";
//}