Miscellany

 <?
$sorgu = mysql_query("SELECT urunler.id as id,katid,name,special,origin,finish,packing,app,size,app2,yeniurun,promosyonurun, resim.id as resim_id,resim_adi FROM urunler LEFT JOIN resim ON urunid = urunler.id WHERE yeniurun = 1 ORDER BY urunler.id");
 
	while($kayit = mysql_fetch_object($sorgu)) {
 
	echo "<h1>".$kayit->name."</h1>";
	echo '<div class="productbox">';
if (!empty($kayit->resim_adi)) echo '<p><a href="resimler/'.$kayit->resim_adi.'" target="_yeni" rel="lightbox[roadtrip]" title="'.$kayit->name.'"><img src="thumb.php?image=resimler/'.$kayit->resim_adi.'&w=100&h=100" class="imgborder"></a></p>';
	echo "<p><strong>Special: </strong>".$kayit->special."<br />";
	echo "<strong>Origin: </strong>".$kayit->origin."<br />";
	echo "<strong>Finish: </strong>".$kayit->finish."<br />";
	echo "<strong>Packing: </strong>".$kayit->packing."<br />";
	echo "<strong>Application: </strong>".$kayit->app."<br />";
	echo "<strong>Size: </strong>".$kayit->size."<br />";
	echo "<strong>Application Coverage: </strong>".$kayit->app2."<br />";
echo "<span class='click'>Click To Enlarge Pictures</span><br />
	<a href='mailto:sercotec@sercotec.net?subject=".$kayit->name."'>Quatation/Order request</a></span></p></div>";
	}
?>