<? 
function Cevir($url){
$Tr = array("Ğ","Ü","Ş","İ","Ö","Ç","ğ","ü","ş","ı","ç"," ","+");
$En = array("G","U","S","I","O","C","g","u","s","i","c",".","");
$url =  @str_replace($Tr,$En,$url);
return $url;
}
$kategori="Aşk - Sevgi"; 
$re = mysql_query("SELECT * FROM kategoriler Where kategori='$kategori'"); 
$res = mysql_fetch_array($re); 
$s=$res[adet]; 
if (!$k) 
{ 
$k=0; 
} 
$resultb = mysql_query("SELECT * FROM siteler where kategori='$kategori' and onay='True'  ORDER BY bgelen DESC limit $k,$s"); 
?> 
<table width="130" border="0"> 
<tr> 
<td> 
<? 
$i=1; 
while ($resultat = mysql_fetch_array($resultb)) { 
$hikaye_adi=substr("$resultat[ad]",0,20); 
$sayac=substr("$resultat[bgelen]",0,20); 
echo "<TR>\n"; 
echo "<TD width=800><a target=_blank href=\"".Cevir($resultat[ad])."-".$resultat[sno].".html\">$hikaye_adi</a></br></i></TD>\n"; 
echo "</TR>\n"; 
$i++; 
$s++; 
} 
$query = "SELECT count(*) as count FROM siteler where kategori='$kategori' and onay='True' "; 
$result = mysql_query($query); 
$row = mysql_fetch_array($result); 
$numrows = $row['count']; 
if($numrows > ($res[adet]))                                                 { 
?></td> 
</tr> 
<tr> 
<td><? echo "<b><A href=\"ask_.html"."\" alt=\"Pop Window\">\n"; 
echo "Devami &gt;&gt;</a></b>"; ?></td> 
</tr><? } ?> 
</table> 
</body> 
</html>