<?php
$kat = mysql_fetch_assoc(mysql_query("SELECT * FROM kategoriler where id='".$_GET["id"]."'"));
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />

 <div class="center_title_bar"><?php echo $kat["kategoriler"]; ?></div>
<?
      $s=mysql_query("select * from ilan where secim=1 and kategori_id='".$_GET["id"]."' order by id desc");
        while($oku=mysql_fetch_array($s)){
			$uye = mysql_fetch_assoc(mysql_query("SELECT * FROM uyeler where id='".$oku["uye_id"]."'"));
			$kat = mysql_fetch_assoc(mysql_query("SELECT * FROM kategoriler where id='".$oku["kategori_id"]."'"));
	?>
<div class="prod_box">

            <div class="center_prod_box">            
                 <div class="product_title"><a href="sayfa.php?sayfa=ilan&id=<?php echo $oku['id']; ?>"><?php echo $oku['ilan_adi']; ?></a></div>
                 <div class="product_img"><a href="sayfa.php?sayfa=ilan&id=<?php echo $oku['id']; ?>"><img src="images/<?php echo $oku['resim']; ?>" alt="" title="" border="0"  width="94"  height="71"/></a></div>
                 <div class="prod_price"><span class="price"><?php echo $uye['adi_soyadi']; ?> TL</span></div>
                 <div class="prod_price"><span class="price"><?php echo $oku['fiyat']; ?> TL</span></div>                  <div class="prod_price"><span class="price"><?php echo $kat['Kategoriler']; ?></span></div>      
          </div>
           
            <div class="prod_details_tab">
          
            <a href="sayfa.php?sayfa=ilan&id=<?php echo $oku['id']; ?>" class="prod_details">Ilana Bak</a>            
            </div>                     
        </div>
    <?
		}
	?>