Unnamed

<?
$id = $_GET["kategori"];
if($id) {
$sql = "SELECT A.altkategoriadi AS akat, K.kategoriadi AS kat, A.id AS Aid, K.id AS Kid FROM kategoriler K INNER JOIN altkategoriler A ON A.katid=K.id WHERE A.id=$id";
$kategoriq = mysql_query($sql);
$kategori = mysql_fetch_array($kategoriq);

$sorgu = mysql_query("SELECT urunler.id as id,katid,name,special,origin,finish,packing,app,size,app2 FROM urunler WHERE katid = $id ORDER BY urunler.id");
 
	while($kayit = mysql_fetch_object($sorgu)) {
	$sorgu2 = mysql_query("SELECT * FROM resim WHERE urunid = ".$kayit->id); 
        $resim = mysql_fetch_object($sorgu2);
	echo '<div class="urunresimholder"><img src="thumb.php?image=resimler/'.$resim->resim_adi.'&w=100&h=100" ></div><div class="urundata"><div class="baslik">'.$kayit->name.'</div>';
				echo "<p><span class='blue'>Special: </span>".$kayit->special."<br />";
	echo "<span class='blue'>Origin: </span>".$kayit->origin."<br />";
	echo "<span class='blue'>Finish: </span>".$kayit->finish."<br />";
	echo "<span class='blue'>Packing: </span>".$kayit->packing."<br />";
		echo "<span class='blue'>Size: </span>".$kayit->size."<br />";
	echo "<span class='blue'>Application Coverage: </span>".$kayit->app2."<br />";
	echo "<span class='blue'>Application: </span>".$kayit->app."<br />";
echo "<span class='click'>Click To Enlarge Pictures</span><br />
	<a href='mailto:info@bonapietra.com?subject=".$kayit->name."'>Quatation/Order request</a></span></p></div>";
	echo '<div id="uygulamalar">';
	echo '<div class="baslik">Product Applications</div>';
while ($resim = mysql_fetch_object($sorgu2)) echo '<a href="/Stones Source/resimler/'.$resim->resim_adi.'" target="_yeni" rel="lightbox[roadtrip]" title="'.$kayit->name.'"><img src="thumb.php?image=resimler/'.$resim->resim_adi.'&w=100&h=100" ></a>';
	echo '</div><hr />';
	}
	}
?>