$mansetler = mysql_query("SELECT * FROM emlak order by id desc LIMIT 0,7");
while($manset = mysql_fetch_array($mansetler))
{
$mansetlerCO = mysql_query("SELECT * FROM resimler where emlak='".$manset['id']."'");
if($mansetCO = mysql_fetch_array($mansetlerCO))
{
}
?>
$rastgeleler = mysql_query("SELECT * FROM emlak WHERE durum=2 and onay=1 order by id desc LIMIT 8");
while($rastgele = mysql_fetch_array($rastgeleler))
{
?>
$rastgeleler = mysql_query("SELECT * FROM emlak WHERE durum=1 and onay=1 order by id desc LIMIT 4");
while($rastgele = mysql_fetch_array($rastgeleler))
{
?>