<?php
include("ayar.php");
$ids= $_GET["id"];
$limit    = 10;
    $sira    = $_GET["sira"];    
    if(empty($sira) or !is_numeric($sira)){
    $sira    = 1;    
}
        $sorgu = $conn->prepare("SELECT COUNT(*) FROM konular WHERE katid='$ids' limit 0,10");
        $sorgu->execute();
        $satirsayisi = $sorgu->fetchColumn();
        $toplamsayfa    = ceil($satirsayisi / $limit);
        $baslangic        = ($sira-1)*$limit;
$sor  = $conn->query("SELECT * FROM konular WHERE katid='$ids' limit 0,10")->fetch(PDO::FETCH_ASSOC);
if($sor<1){
echo "YOK";
}else{ 
        $id  = $sor["id"];
    $adi = $sor["adi"];
  echo"<td><a href='oku.php?id=$id'>$adi</a></td></tr>";
}
?>