$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); echo '

Special: ".$kayit->special."
";
echo "Origin: ".$kayit->origin."
";
echo "Finish: ".$kayit->finish."
";
echo "Packing: ".$kayit->packing."
";
echo "Size: ".$kayit->size."
";
echo "Application Coverage: ".$kayit->app2."
";
echo "Application: ".$kayit->app."
";
echo "Click To Enlarge Pictures
Quatation/Order request