Søge-funktion, men mit script til "WHERE" driller..
<?$pcmin = $_GET['pcmin'];
$pcmax = $_GET['pcmax'];
$type = $_GET['type'];
$size = $_GET['size'];
$minrooms = $_GET['minrooms'];
$maxrooms = $_GET['maxrooms'];
$minlevel = $_GET['minlevel'];
$maxlevel = $_GET['maxlevel'];
$elevator = $_GET['elevator'];
$animals = $_GET['animals'];
$rent = $_GET['rent'];
$where = '';
$i = 0;
if ($pcmin != "") {
if ($i > 0) { $where .= " AND "; }
$where = $where . "postalcode >= \"$pcmin\"";
$i++;
}
if ($pcmax != "") {
if ($i > 0) { $where .= " AND "; }
$where = $where . "postalcode =< \"$pcmax\" ";
$i++;
}
if ($type != "") {
if ($i > 0) { $where .= " AND "; }
$where = $where . "type = \"$type\" ";
$i++;
}
if ($size != "") {
if ($i > 0) { $where .= " AND "; }
$where = $where . "areal > \"$size\" ";
$i++;
}
if ($minrooms != "") {
if ($i > 0) { $where .= " AND "; }
$where = $where . "rooms >= \"$minrooms\" ";
$i++;
}
if ($maxrooms != "") {
if ($i > 0) { $where .= " AND "; }
$where = $where . "rooms =< \"$maxrooms\" ";
$i++;
}
if ($minlevel != "") {
if ($i > 0) { $where .= " AND "; }
$where = $where . "etage >= \"$minlevel\" ";
$i++;
}
if ($maxlevel != "") {
if ($i > 0) { $where .= " AND "; }
$where = $where . "etage =< \"$maxlevel\" ";
$i++;
}
if ($animals != "") {
if ($i > 0) { $where .= " AND "; }
$where = $where . "husdyr =< \"$animals\" ";
$i++;
}
if ($rent != "") {
if ($i > 0) { $where .= " AND "; }
$where = $where . "rent < \"$rent\" ";
$i++;
}
$foresp = mysql_query("SELECT * FROM annonce WHERE " . $where . " ORDER BY id DESC");
while ($data = mysql_fetch_array($foresp)){
$emne = $data[emne];
$areal = $data[areal];
echo $areal . $emne;
}
?>
------------------------
Det virker ikke rigtigt, output er:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a7529669/public_html/_search.php on line 69
Jeg HAR tjekket, og hvis man skrive:
print $where;
giver det en helt normal sætning, som jeg selv ville skrive den hvis det hele var forudbestemt og ikke skulle være variable :) (hvis I forstår)
