$sira = 0;
foreach($archive as $a){
    $sira++;
}

$limit = 30;
$ilk = $limit*($sayfa-1);
$archive = $db->get_results("select * ....... DESC limit $ilk,$limit");
$sira = $limit*($sayfa-1);
foreach($archive as $a){
    $sira++;
}