gan ane kesulitan buat paging nh, bisa di review ga??
ni scriptnya


<?php
$sql = mysql_query("SELECT A.*, (SELECT COUNT(NPK) FROM TABEL_B WHERE NPK=A.NPK) AS jumlah FROM TABEL_B A ORDER BY A.NPK ASC " );
$no = 1;
$jum = 1;
echo '<table cellpadding="5 " border="1" align="center">';
echo '<tr><th>NPK</th><th>PERIJINAN</th><th>TANGGAL MASUK</th><th>TANGGAL KELUAR</th><th>STATUS</th></tr>';
while($row = mysql_fetch_array($sql)) {
echo '<tr>';
if($jum <= 1) {
echo '<td rowspan="'.$row['jumlah'].'">'.$row['NPK'].'</td>';
$jum = $row['jumlah'];
$no++;
} else {
$jum = $jum - 1;
}
echo '<td>'.$row['PERIJINAN'].'</td>';
echo '<td>'.$row['TGL_IN'].'</td>';
echo '<td>'.$row['TGL_OUT'].'</td>';
echo '<td>';if($row["TGL_IN"] < $row["TGL_OUT"]){
echo "<font color='red'><font size=3>Aktiv ";
}
else
{
echo "<font color='blue'><font size=3><b>Off </b></font>";
}'</td>';
echo '</tr>';
}
echo '</table>';


?>



<?//maunya kyak gini gan, tapi yg dinamis?>

<?php
$per_page =1;
$page_query = mysql_query("select count(NPK) from TABEL_B");
$pages = ceil(mysql_result($page_query, 0) / $per_page);
$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $per_page;
$query = mysql_query("SELECT DISTINCT(NPK) FROM TABEL_B LIMIT $start, $per_page");
while($query_row = mysql_fetch_assoc($query)){
echo '<p>'.$query_row['NPK'].'</p>';
}
?>
<?php
$per_page =3;
$page_query = mysql_query("select count(*) from TABEL_B");
$pages = ceil(mysql_result($page_query, 0) / $per_page);
$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $per_page;
$query = mysql_query("SELECT PERIJINAN,TGL_IN,TGL_OUT FROM TABEL_B LIMIT $start, $per_page");
while($query_row = mysql_fetch_assoc($query)){
echo '<p>'.$query_row['PERIJINAN'].' - '.$query_row['TGL_IN'].' - '.$query_row['TGL_OUT'].'</p>';
}
if ($pages >=1 && $page <= $pages) {
for ($x=1; $x<=$pages; $x++){
echo ($x == $page) ? '<b> <a href="?page='.$x.'">'.$x.'</a></b> ' : '<a href="?page='.$x.'">'.$x.'</a>';
}
}
?>