3 Soru: Arama Kaydetme, Aramaları Sıralama ve Arama Sonucu yoksa....

order by id desc

<?php
include("arabaglanti.php");
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET latin5");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
echo "<table width=\"30%\">
<tr>
<td width=\"70%\"><b><font color=\"red\">Kelime</font></b></td>
<td width=\"30%\"><b><font color=\"red\">Hit</font></b></td>

</tr>
</table>";
$sor = mysql_query("SELECT * FROM arama ORDER BY id DESC limit 0,40");
$bulunan=0;
while($yaz=mysql_fetch_array($sor)){
$bulunan++;
$kelime = $yaz['kelime'];
$hit = $yaz['hit'];
$id = $yaz['id'];


echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"white\" width=\"30%\" id=\"AutoNumber2\">
<tr>
<td width=\"70%\"><a href=\"ara.php?kelime=$kelime\">$kelime</a></td>
<td width=\"30%\">$hit</a></td>
</tr>
</table>";
}
if ($bulunan==0){
echo "<br><br> Aradığınız kriterlerde bir kayıt bulunmamaktadır.Onun yerine biz size rastgele oyunları gösterelim"; 

$i=0; $sql=mysql_query("select * from oyunlar order by Rand() limit 4");
while ($yaz=mysql_fetch_array($sql))
{ $title=$yaz[title];$resim=$yaz[resim];$hit=$yaz[hit];$kid=$yaz[kid];$sef=$yaz[sef];
$sel=mysql_query("select * from kategoriler where id='".$kid."'");
while ($aldik=mysql_fetch_array($sel)){$kat=trle($aldik['adi']);}
$yazalim="<a href='/".$kat."/".$sef.".html'>".$title."</a>";
$ressam="<a href='/".$kat."/".$sef.".html'><img src='".$resim."' alt='".$title."' width='100' border='0' height='90' /></a>";
?>

<div class="moa1">
<div class="roa1" style="width: 100px; margin-bottom: 1px;">
<?=$ressam;?>
</div>
<h3 class="hba1"><?=$yazalim;?></h3>
</div>
<?}?> 
	<? } ?>

function replace_tr($text) {
$text = trim($text);
$search = array('Ç','ç','Ğ','ğ','ı','İ','Ö','ö','Ş','ş','Ü','ü',' ');
$replace = array('C','c','G','g','i','I','O','o','S','s','U','u','+');
$new_text = str_replace($search,$replace,$text);
return $new_text;
}

$kelime = replace_tr($yaz['kelime']);