<?php



$limit  = "20";
$sayfa = (!empty($_GET['sayfa'])) ? (int)$_GET['sayfa'] : 1;
$toplam_kayit  = mysql_num_rows(mysql_query("SELECT id FROM imza"));



$offset =  $sayfa * $limit;

$offset = $offset - $limit;

$sayfa_sayisi  =  ceil($toplam_kayit / $limit);



$sorgu = "SELECT * FROM imza ORDER BY `id` desc LIMIT ".$limit." OFFSET ".$offset;


$sorgulama = @mysql_query($sorgu);
if (@mysql_num_rows($sorgulama)>0){
//kayıtları listele
while ($kayit=@mysql_fetch_assoc($sorgulama)){
###################### var ##############################################
$isim=$kayit["isim"];
$meslek=$kayit["meslek"];
$sehir=$kayit["sehir"];

echo "<tr>
    <td><font color=\"#000000\" face=\"verdana\" size=\"2\">$isim</font></td>
    <td><font color=\"#000000\" face=\"verdana\" size=\"2\">$meslek</font></td>
    <td><font color=\"#000000\" face=\"verdana\" size=\"2\">$sehir</font></td>
  </tr>";
}
}


?>





<?php

        
        for($i = 1; $i <= $sayfa_sayisi; $i++)
        {
            if($i == $sayfa)
            {
                echo "<strong>".$i."</strong>";
                
            }
            else
            {
            
                echo "[<a href=?sayfa=".$i.">".$i."</a>]";    
            }
        }







?>