kategoriye bağlı ürün listeleme

 <li> 
            <table cellspacing="1" cellpadding="4" border="0" align="left"> 
              <tr> 
               
    <?php 
   
  include ("Connections/baglan.php"); 
   
  $sorgu=mysql_query("SELECT urunler.*,kategoriler.* FROM urunler INNER JOIN kategoriler ON('urunler.kat_id=kategoriler.id') order by urunler.id DESC limit 20"); 
  $sayi=0; 
   
  while($yaz=mysql_fetch_assoc($sorgu)) 
   
   
  { 
  if(($sayi != 0) AND ($sayi % 2) == 0) echo '</tr><tr>';   
  ?> 
    
  <td align="left"><span class="goster"><?php echo $yaz['baslik'];?> <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=90055628&url=images_up/<?php echo $yaz['resim'];?>" title="" target="_blank" data-href="images_up/<?php echo $yaz['resim'];?>" title="" target="_blank"> <img src="images_up/<?php echo $yaz['resim']; ?>"width="322" height="158" border="0" /> </a></span></td> 
               <?php 
  $sayi++; 
  } 
  ?> 
   
      </tr> 
            </table> 
          </li>

<? 
  include ("Connections/baglan.php"); 
  $katid	=	$_GET["id"]; 
  $kategoriler	=	@mysql_fetch_array(@mysql_query("SELECT * FROM kategoriler WHERE id='$katid' limit 1")); 
  	$kid		=	$kategoriler["id"]; 
  	$kbaslik	=	$kategoriler["baslik"]; 
  	$kseo	    =	$kategoriler["baslik_seo"]; 
  	 
  ?> 
   
  <?=$kbaslik?> <?=$kseo?> 
  	 
  	 
  <?  
  $sorgu	=	@mysql_query("SELECT * FROM urunler WHERE kat_id='".$katid."' ORDER BY id limit 10"); 
  while($row = @mysql_fetch_array($sorgu)){ 
  	$id			=	$row["id"] 
  	$baslik		=	$row["baslik"]; 
  	$baslik_seo	=	$row["baslik_seo"]; 
  	$icerik		=	$row["icerik"]; 
  	$resim 		=	$row["resim "];	 
  ?> 
  	 
  	 
  <?=$baslik?><br> 
  <?=$baslik_seo?><br> 
  <?=$icerik?><br> 
  <?=$resim?> 
   
   
  <? } ?>