='30000000') and "; } elseif ($_POST["ar"]==2){ $sql.= "(Ar between 10000000 and 15000000) and "; } elseif ($_POST["ar"]==3){ $sql.= "(Ar between 15000000 and 20000000) and "; } elseif ($_POST["ar"]==4){ $sql.= "(Ar between 20000000 and 25000000) and "; } elseif ($_POST["ar"]==4){ $sql.= "(Ar between 25000000 and 30000000) and "; } } $sql.=" (1=1) "; //echo $sql; $temp=''; $hatter=0; $dbh = @mysql_connect($host, $user, $passw); mysql_select_db($database); $sth = mysql_query($sql); while ($rs = mysql_fetch_object($sth)) { if ($hatter%2==0){ $hszin='#F5F3F3'; }else $hszin='#c0c0c0'; $temp.=" "; $temp1=""; $be = $rs->BEIDO; $mai = getdate(); $be_ho =substr($be, 5, 2); $be_nap =substr($be, 8, 2); $be_ev =substr($be, 0, 4); $mai_nap=$mai['mday']; $mai_ho=$mai['mon']; $mai_ev=$mai['year']; $bejov = mktime (0,0,0,$be_ho,$be_nap,$be_ev); $mama = mktime (0,0,0,$mai_ho,$mai_nap,$mai_ev); $temp.="".$rs->id."
"; if (($mama-$bejov)<604801) $temp.=( "

"); $temp.=( ""); $temp.=""; $keplink="index.php?menu=21&id=".$rs->id; if (strlen($rs->kep1)>0) { $temp.=(""); $temp.=( "

kep1." border=\"0\" width=\"60\" height=\"40\">"); $temp.=( ""); } else $temp.=( "Nincs kép\n" ); $szoba=""; $szobba=""; if (($rs->szoba)>0) { $szoba=$rs->szoba; $szobba="szoba"; } $nm=$rs->nm; $temp.="".$rs->hely." ".$rs->tipus.""; $temp.= ""; $temp.="".$szoba.""; if (strlen($rs->ar)==0) {$ar="Ár nélküli";} else {$ar=$rs->ar." Ft";} $temp.=" "; $temp.=" "; $temp.="

".$ar.""; $temp.=""; $temp.="

".$nm." m²"; $temp.="".$szobba.""; $temp.=""; $temp.="".$rs->leiras.""; if ($hatter%2==0){ $hszin='#F5F3F3'; }else $hszin='#c0c0c0'; $hatter++; } mysql_free_result($sth); mysql_close($dbh); $subtitle.=" ( ".$hatter." db )"; if ($hatter==0) $temp='Sajnos nincs ilyen ingatlan az adatbázisunkban, kérjük érdeklõdjön telefonon.'; ?>