<table width="940">
<tr>
<? $ip=0;
$sayfa=$_GET['sayfa'];
if (!is_numeric($sayfa) || $sayfa=="") { $sayfa=1; }
$kaydet = mysql_num_rows(mysql_query("Select * from arama where kelime = '".$kelime."'"));
if($kaydet==0) {
@mysql_query("Insert Into arama (kelime,hit) values ('".$kelime."','1')");
}else{
@mysql_query("Update arama set hit = hit+1 where kelime = '".$kelime."'");
}
$kacar=40;
$kayit_sayisi=mysql_fetch_array(mysql_query("SELEC T COUNT(*) FROM oyunlar WHERE title LIKE '%$kelime%'"));
$sayfa_sayisi=$kayit_sayisi['0']/$kacar;
if ($sayfa_sayisi%$kacar!=0) { $sayfa_sayisi++; }
$nerden=($sayfa*$kacar)-$kacar;
$sql=mysql_query("SELECT * FROM oyunlar WHERE title LIKE '%$kelime%' ORDER BY id DESC LIMIT $nerden, $kacar");
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='170' border='0' height='135' /></a>";

?>

<td onmouseover="bgColor='#82BFFF'" onmouseout="bgColor='#ffffff'" align="center" valign="top" style="cursor:hand">



<div class="moa">
<div class="roa" style="width: 175px; margin-bottom: 3px;">
<?=$ressam;?>
</div>
<h2 class="hba"><?=$yazalim;?></h2>
<div>oyun <?=$hit;?> oynandı</div>
</div>





</td>
<?$i++; if ($i==5 or $i==10 or $i==15 or $i==20 or $i==25 or $i==30 or $i==35 or $i==40){?>
</tr>
</table>
<table width="940" border="0">
<tr><? }else{?> <?}}?>
<td></td>
</tr>
</table>