ana_sayfa.php :
<?php require_once('Connections/baglan.php'); ?>
<?php
mysql_select_db($database_baglan, $baglan);
$query_tum_kategoriler = "SELECT * FROM emlak_kategori";
$tum_kategoriler = mysql_query($query_tum_kategoriler, $baglan) or die(mysql_error());
$row_tum_kategoriler = mysql_fetch_assoc($tum_kategoriler);
$totalRows_tum_kategoriler = mysql_num_rows($tum_kategoriler);
mysql_select_db($database_baglan, $baglan);
$emlak_sayac = mysql_query("SELECT * FROM emlak_emlak WHERE emlak_durum > 0 and !isnull(emlak_emlak.emlak_sozlesme_bit) <= if(emlak_emlak.emlak_sozlesme_bit > now(),1,0)", $baglan) or die(mysql_error());
$toplam_emlak_sayac = mysql_num_rows($emlak_sayac);
$gosterilecek_emlak = 15;
$rnd_son = $toplam_emlak_sayac - $gosterilecek_emlak - 1;
if ($rnd_son < 0){$rnd_son = 0;};
$query_vitrin = "SELECT * FROM emlak_emlak left join emlak_danisman on (emlak_danisman.danisman_id = emlak_emlak.emlak_danisman_id) left join emlak_kategori on (emlak_kategori.kategori_id=emlak_emlak.emlak_kategori_id) left join emlak_resim on (emlak_resim.resim_emlak_id=emlak_emlak.emlak_id) WHERE emlak_emlak.emlak_durum > 0 and !isnull(emlak_emlak.emlak_sozlesme_bit) <= if(emlak_emlak.emlak_sozlesme_bit > now(),1,0) group by emlak_emlak.emlak_id ORDER BY emlak_id DESC LIMIT 0,$gosterilecek_emlak";
$vitrin = mysql_query($query_vitrin, $baglan) or die(mysql_error());
$row_vitrin = mysql_fetch_assoc($vitrin);
$totalRows_vitrin = mysql_num_rows($vitrin);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9">
</head>
<body>
<span class="baslik"></span>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><span class="baslik"><strong> </strong></span> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><table width="98%" border="0" align="center" cellspacing="0" cellpadding="0">
<tr>
<td width="88%"><div align="justify"><span class="guncel_yazi"><?php echo $row_metinler['metin_ana_metin']; ?></span></div></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1"><hr size="1" class="hr"></td>
</tr>
<tr>
<td height="27"><span class="baslik2"><a href="?sayfa=emlak_ara&durum=satilik" class="baslik2"><strong><img src="diplomatic-images/all_list.gif" border="0" align="absmiddle"> <img src="diplomatic-images/diplomatic_cars.gif" border="0" align="absmiddle"> <?php echo $row_metinler['metin_vitrin']; ?></strong></a></span></td>
</tr>
<tr>
<td height="1"><hr size="1" class="hr"></td>
</tr>
</table> <?php if ($totalRows_vitrin){ ?>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<?php do {
$emlak_resimler = mysql_query("SELECT * FROM emlak_resim WHERE resim_emlak_id = '".$row_vitrin["emlak_id"]."' ORDER BY resim_id ASC LIMIT 0,1", $baglan) or die(mysql_error());
$row_emlak_resimler = mysql_fetch_assoc($emlak_resimler);
?>
<tr>
<td width="50%">
<table width="176" height="210" border="0" align="center" cellpadding="4" cellspacing="0" background="resimler/anasayfa_arac_bg.gif" onClick="window.location='?sayfa=emlak_detay&id=<?php echo $row_vitrin['emlak_id']; ?>';" style="cursor:pointer;">
<tr>
<td align="center"><a href="?sayfa=emlak_detay&id=<?php echo $row_vitrin['emlak_id']; ?>" title="<?php echo $row_metinler['metin_detaylar']; ?>"><img src="<?php if ($row_emlak_resimler['resim_isim'] != ""){echo "resim_goster.php?yol=".$row_emlak_resimler['resim_isim']."&en=150&boy=120";} else {echo "resimler/".$row_imajlar["imaj_resimsiz"];} ?>" width="150" height="120" border="1" class="resim"></a></td>
</tr>
<tr>
<td align="center"><span class='kategori'><strong><?php echo $row_vitrin['emlak_il']; ?></strong></span> <span class='kategori'><strong><?php echo $row_vitrin['emlak_adres'];?></strong></span><br><span class='kategori'><strong><?php echo $row_emlak_detay['emlak_renk']; ?> 1</strong> - <?php echo $row_emlak_detay['emlak_km']; ?></strong> <?php echo $row_emlak_detay['emlak_kmtur']; ?></span>
<span class="guncel_yazi"><?php echo $row_metinler["metin_subeler"];?> : <strong><?php echo $row_vitrin['emlak_ilce']; ?></strong></span>
<span class="guncel_yazi"><?php if ($row_vitrin['emlak_satilik']==1){ echo "<br>".$row_metinler['metin_fiyati']." : <strong>".number_format($row_vitrin['emlak_fiyat_satilik'],'','','.')." ".$row_vitrin['emlak_fiyat_satilik_doviz']."</strong>";} ?></span> </td>
</tr>
</table> </td>
<td>
<?php
$row_vitrin = mysql_fetch_assoc($vitrin);
$emlak_resimler = mysql_query("SELECT * FROM emlak_resim WHERE resim_emlak_id = '".$row_vitrin["emlak_id"]."' ORDER BY resim_id ASC LIMIT 0,1", $baglan) or die(mysql_error());
$row_emlak_resimler = mysql_fetch_assoc($emlak_resimler);
?> </td>
<td width="50%">
<?php if ($row_vitrin["emlak_id"] != ""){ ?>
<table width="176" height="210" border="0" align="center" cellpadding="4" cellspacing="0" background="resimler/anasayfa_arac_bg.gif" onClick="window.location='?sayfa=emlak_detay&id=<?php echo $row_vitrin['emlak_id']; ?>';" style="cursor:pointer;">
<tr>
<td align="center"> <a href="?sayfa=emlak_detay&id=<?php echo $row_vitrin['emlak_id']; ?>" title="<?php echo $row_metinler['metin_detaylar']; ?>"></a><a href="?sayfa=emlak_detay&id=<?php echo $row_vitrin['emlak_id']; ?>" title="<?php echo $row_metinler['metin_detaylar']; ?>"><img src="<?php if ($row_emlak_resimler['resim_isim'] != ""){echo "resim_goster.php?yol=".$row_emlak_resimler['resim_isim']."&en=150&boy=120";} else {echo "resimler/".$row_imajlar["imaj_resimsiz"];} ?>" width="150" height="120" border="1" class="resim"></a></td>
</tr>
<tr>
<td align="center"><span class='kategori'><strong><?php echo $row_vitrin['emlak_il']; ?></strong></span> <span class='kategori'><strong><?php echo $row_vitrin['emlak_adres'];?></strong></span><br>
<span class="guncel_yazi"><?php echo $row_metinler["metin_subeler"];?> : <strong><?php echo $row_vitrin['emlak_ilce']; ?></strong></span>
<span class="guncel_yazi"><?php if ($row_vitrin['emlak_satilik']==1){ echo "<br>".$row_metinler['metin_fiyati']." : <strong>".number_format($row_vitrin['emlak_fiyat_satilik'],'','','.')." ".$row_vitrin['emlak_fiyat_satilik_doviz']."</strong>";} ?></span> </td>
</tr>
</table>
<?php } ?></td>
<td><?php
$row_vitrin = mysql_fetch_assoc($vitrin);
$emlak_resimler = mysql_query("SELECT * FROM emlak_resim WHERE resim_emlak_id = '".$row_vitrin["emlak_id"]."' ORDER BY resim_id ASC LIMIT 0,1", $baglan) or die(mysql_error());
$row_emlak_resimler = mysql_fetch_assoc($emlak_resimler);
?></td>
<td width="50%"><table width="176" height="210" border="0" align="center" cellpadding="4" cellspacing="0" background="resimler/anasayfa_arac_bg.gif" onClick="window.location='?sayfa=emlak_detay&id=<?php echo $row_vitrin['emlak_id']; ?>';" style="cursor:pointer;">
<tr>
<td align="center"><a href="?sayfa=emlak_detay&id=<?php echo $row_vitrin['emlak_id']; ?>" title="<?php echo $row_metinler['metin_detaylar']; ?>"></a><a href="?sayfa=emlak_detay&id=<?php echo $row_vitrin['emlak_id']; ?>" title="<?php echo $row_metinler['metin_detaylar']; ?>"><img src="<?php if ($row_emlak_resimler['resim_isim'] != ""){echo "resim_goster.php?yol=".$row_emlak_resimler['resim_isim']."&en=150&boy=120";} else {echo "resimler/".$row_imajlar["imaj_resimsiz"];} ?>" width="150" height="120" border="1" class="resim"></a></td>
</tr>
<tr>
<td align="center"><span class='kategori'><strong><?php echo $row_vitrin['emlak_il']; ?></strong></span> <span class='kategori'><strong><?php echo $row_vitrin['emlak_adres'];?></strong></span><br>
<span class="guncel_yazi"><?php echo $row_metinler["metin_subeler"];?> : <strong><?php echo $row_vitrin['emlak_ilce']; ?></strong></span> <span class="guncel_yazi">
<?php if ($row_vitrin['emlak_satilik']==1){ echo "<br>".$row_metinler['metin_fiyati']." : <strong>".number_format($row_vitrin['emlak_fiyat_satilik'],'','','.')." ".$row_vitrin['emlak_fiyat_satilik_doviz']."</strong>";} ?>
</span> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="5" colspan="5"><div align="center"></div></td>
</tr>
<?php } while ($row_vitrin = mysql_fetch_assoc($vitrin));?>
</table>
<?php }; ?>
</td>
</tr>
<tr>
<td height="27" align="right"><span class="baslik2"><a href="?sayfa=emlak_ara&durum=satilik" class="baslik2"><strong> <?php echo $row_metinler['metin_vitrin']; ?></strong></a></span> <img src="diplomatic-images/diplomatic_cars.gif" border="0" align="absmiddle"> <img src="diplomatic-images/all_list.gif" border="0" align="absmiddle"> </td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($tum_kategoriler);
mysql_free_result($vitrin);
?>