Mysqlden gelen verileri nasıl sayfalama yapabilirim.?

<?php
include("vt.php");
$id=$_GET["id"];
$katadi=mysql_query("SELECT * from kategori where id='".$_GET["id"]."'");
$makalecek=mysql_fetch_array(mysql_query("select * from yazilar where id='$id'"));
$baslik=$makalecek['baslik'];
$makale=$makalecek['yazi_metni'];
$hit=$makalecek['hit'];
$uye=$makalecek['uye'];
?>
<?php
$id=$_GET["id"];
$s = $_GET['page'];
if($s == "")
 $s = 0;
 else
  $s = ($s-1) * 5;
$katcek=mysql_query("select * from yazilar where katid='".$id."' order by id desc limit $s,3");  
while($yaz=mysql_fetch_array($katcek))
{  
$id=$yaz['id'];  
$baslik=$yaz['baslik'];  
$hit=$yaz['hit'];  
$uye=$yaz['uye'];  
$yazi_metni=$yaz['yazi_metni'];  
echo "<a href=\"http://www.site.com/".$id."-".seo($baslik).".html\">".$baslik."</a><br>";  
}
;
?>
<?php
$limit = 5;
$page = @$_GET["page"];
if(empty($page) or !is_numeric($page)) {
$page = 1;
}
    $count             = mysql_num_rows(mysql_query("SELECT id FROM yazilar"));
    $toplamsayfa     = ceil($count / $limit);
    $baslangic         = ($page-1)*$limit;
$sorgu = "SELECT * FROM yazilar ORDER BY id ASC LIMIT $baslangic,$limit";
if($count > $limit) : 
  $x = 3;
  $lastP = ceil($count/$limit); 
  for($i; $i<=$page+$x; $i++) { 
    if($i==$page) echo ""; 
    else echo "<a href=\"?id=1&page=$i\">[$i]</a>"; 
    if($i==$lastP) break; 
  } 
  if($page+$x < $lastP-1) { 
    echo "<a href=\"?id=1&page=$lastP\">[$lastP]</a>"; 
  }
endif;
?>

RewriteRule ^kategori-(.*)-([0-9]+)$              kategori.php?id=$1&page=$2       [L]