Forum Informatika

Kamu lihat query mysql yang ada klausa LIMIT

misalkan

$jum=mysql_num_rows($qry);
//query mengitung total record

//query menampilkan per halaman
$qry="SELECT * ... LIMIT $start,$ahir;

//tampilkan disini
echo "$start - $akhir of $jum records";

$awal=$HTTP_GET_VARS["awal"];
if(empty($awal))
$awal=0;
$batas=3;//atur paging batasnya disini..
$string="select * from databasenya limit $awal,$batas";
$query=mysql_query($string);



$atuh="select * from databasenya";
$beta=mysql_query($atuh);
$num=mysql_num_rows($beta);
$j=ceil($num/$batas);

if($awal!=$awal1){
$first=0;
echo "<a href="$PHP_SELF?menu=home&awal=$first" class="a"><b>First</b></a> &nbsp;";
}
else {
echo "first";
}
for($i=1;$i<=$j;$i++){
$awal1=ceil($i*$batas)-$batas;
if($awal!=$awal1){
echo "<a href="$PHP_SELF?menu=home&awal=$awal1" class="a"><b>$i</b> </a>";
}
else {
echo " [$i] ";
}
}
if($awal>=0 && $awal<=$j && $j>1){
$page=ceil($num/$batas);
$last=($page*$batas)-$batas;
echo "<a href="$PHP_SELF?menu=home&awal=$last" class="a"><b>Last </b></a>";
}
else {
echo "Last";
}