PHP development paging implementation code

;
$page=($pageval-1)*$pagesize;
$page.=',';
}
if($num > $pagesize){
if($pageval<=1)$pageval=1;
echo "Total $num bars".
" <a href=$url?page=".($pageval-1).">Previous page</a> <a href=$url?page=".($pageval+1).">Next page</a>";
}
$SQL="SELECT * FROM `test` limit $page $pagesize ";
$query=mysql_query($SQL);
while($row=mysql_fetch_array($query)){
echo "<hr><b>".$row[name]." | ".$row[sex];
}
?>
[/code]
Paging formula: (current page number - 1) * Number of bars per page, number of bars per page
sql statement: select * from test_table limit ($page-1)*$pageSize,$pageSize;