Unnamed

 <?
$id = $_GET["kategori"];
if($id) {

$sorgu = mysql_query("SELECT urunler.id as id,katid,name,special,origin,finish,packing,app,size,resim.id as resim_id,resim_adi FROM urunler LEFT JOIN resim ON urunid = urunler.id WHERE katid = $id ORDER BY urunler.id");
 
	while($kayit = mysql_fetch_object($sorgu)) {
 
	echo '<div class="productbox">';
if (!empty($kayit->resim_adi)) echo '<p><a href="resimler/'.$kayit->resim_adi.'" target="_yeni" rel="lightbox[roadtrip]" title="'.$kayit->special.'"><img src="thumb.php?image=resimler/'.$kayit->resim_adi.'&w=100&h=100" class="imgborder"></a></p>';
echo "<p><strong>&raquo;".$kayit->name."</strong></p></div>";
 
	}
	}
?>