<?php 
$sayfa=$_GET['sayfa']; 
$id=$_GET["id"]; 
if ($sayfa=="" || !is_numeric($sayfa)) { 
$sayfa=1; 
} 
$kacar=3; 
$kayit_sayisi=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM download")); 
$sayfa_sayisi=$kayit_sayisi['0']/$kacar; 
if ($kayit_sayisi%$kacar!=0) { 
$sayfa_sayisi++; 
} 
$nerden=($sayfa*$kacar)-$kacar; 
$katcek=mysql_query("select * from download where katid='$id' order by id desc LIMIT $nerden,$kacar "); 
while($yaz=mysql_fetch_array($katcek)){ 
$id=$yaz['id']; 
$isim=$yaz['isim']; 
$demo=$yaz['demo']; 
$resim=$yaz['resim']; 
$dosya=$yaz['dosya']; 
 echo " 
<table> 
  <tbody> 
    <tr> 
      <td colspan=\"2\" rowspan=\"1\"><a href=template.php?id=$id><fon size=10><center>$isim</center></font></a></td> 
    </tr> 
    <tr> 
      <td colspan=\"2\" rowspan=\"1\" style=\"height: 2px;\"><img title=\"$isim\" src=$siteadresi->siteadresi/deneme/onizleme/$isim.jpg></td> 
    </tr> 
    <tr><td>&nbsp;</td><td>&nbsp;</td></tr> 
    <tr> 
      <td><a href=template.php?id=$id><center>Download<center></a></td><td><a href=\"$demo\">Demo</a></td> 
    </tr> 
    <tr><td>&nbsp;</td><td>&nbsp;</td></tr> 
    <tr><td>&nbsp;</td><td>&nbsp;</td></tr> 
  </tbody> 
</table>"; 
 } 
echo "<br>"; 
for ($i=1; $i<=$sayfa_sayisi; $i++) { 
echo "<a href=kategori.php?id=$id&sayfa=$i>$i</a>"; 
} 
?>