Buyur


$sorgu=mysql_query("SELECT * FROM kategoriler WHERE id='6'");

$kayit=mysql_fetch_array($sorgu);
$kategori = $kayit['kategori'];

$sorgum= mysql_query("select sehir from firmalar order by id desc limit 0,10000");
$kayiti=mysql_fetch_array($sorgum);
$sehir = $kayiti['sehir'];

if ($sehir == $kategori)

{



$sorgu2= mysql_query("select * from firmalar where sehir='$kategori' order by id desc limit 0,10000");
if (mysql_num_rows($sorgu2)){
while($kayit=mysql_fetch_array($sorgu2)){

echo "
";

echo "
" .$kayit["firma"] . "
";
echo "
";
echo "
Telefon Numarası: " . $kayit ["firmatelefon"] . "
";
echo "
Fax Numarası: " . $kayit ["firmafax"] . "
";
echo "
E-Posta Adresi: " . $kayit ["firmamail"] . "
";
echo "
Adres: " . $kayit ["adres"] . "
";
echo "
Web Sitesi: " . $kayit ["firmawebsite"] . "
";
echo "
Çalışma Saatleri: " . $kayit ["firmacalismasaatleri"] . "
";
echo "
Cumartesi: " . $kayit ["cumartesi"] . "
";
echo "
Pazar: " . $kayit ["pazar"] . "
";
echo "
";
echo "
";

echo "
";
}
}


}

?>