= ".$_POST['Zvon']." "; $zimmer = "mehr als ".$_POST['Zvon']." Zimmer"; } elseif (("" == $_POST['Zvon']) AND ("" !== $_POST['Zbis'])) { $filter = $filter. "AND Zimmer <= ".$_POST['Zbis']." "; $zimmer = "bis ".$_POST['Zbis']." Zimmer"; } else { $filter = $filter. "AND Zimmer BETWEEN ".$_POST['Zvon']." AND ".$_POST['Zbis']." "; $zimmer = $_POST['Zvon']." bis ".$_POST['Zbis']." Zimmer"; } if (("" == $_POST['Wvon']) AND ("" == $_POST['Wbis'])) { } elseif (("" !== $_POST['Wvon']) AND ("" == $_POST['Wbis'])) { $filter = $filter. "AND WohnF >= ".$_POST['Wvon']." "; $wohn = "mehr als ".$_POST['Wvon']." m²"; } elseif (("" == $_POST['Wvon']) AND ("" !== $_POST['Wbis'])) { $filter = $filter. "AND WohnF <= ".$_POST['Wbis']." "; $wohn = "bis ".$_POST['Wbis']." m²"; } else { $filter = $filter. "AND WohnF BETWEEN ".$_POST['Wvon']." AND ".$_POST['Wbis']." "; $wohn = $_POST['Wvon']." bis ".$_POST['Wbis']." m²"; } if (("" == $_POST['Kvon']) AND ("" == $_POST['Kbis'])) { } elseif (("" !== $_POST['Kvon']) AND ("" == $_POST['Kbis'])) { $filter = $filter. "AND Mkalt >= ".$_POST['Kvon']." "; $kalt = "mehr als ".$_POST['Kvon']." EUR"; } elseif (("" == $_POST['Kvon']) AND ("" !== $_POST['Kbis'])) { $filter = $filter. "AND Mkalt <= ".$_POST['Kbis']." "; $kalt = "bis ".$_POST['Kbis']." EUR"; } else { $filter = $filter. "AND Mkalt BETWEEN ".$_POST['Kvon']." AND ".$_POST['Kbis']." "; $kalt = $_POST['Kvon']." bis ".$_POST['Kbis']." EUR"; } } echo "

Einzelhandel und Industrie

\n"; $sql = 'SELECT ID, O_TYP, Kurz, Zimmer, WohnF, Ort, Mkalt, Garage, StellPl, Terrasse, Balkon, Garten FROM objekte WHERE '.$filter.' ORDER BY ID ASC'; $result = $db->query($sql); $anzahl = $result->num_rows; echo "
\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (1 !== $anzahl) { echo " \n"; } else { echo " \n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (isset($_POST['formaction'])) { echo " \n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
Suchkriterien$anzahl Objekte im Angebot$anzahl Objekt im Angebot
Zimmer:bismit folgenden Kriterien:
Nutzfläche:bism²$zimmer
$wohn
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($nt = $result->fetch_assoc()) { if (('Einzelhandel - Kauf' == $nt[O_TYP]) OR ('Industrie - Kauf' == $nt[O_TYP])) { $link = ""; } else { $link = ""; } echo " \n"; echo " \n"; echo " \n"; if ('1' == $nt[Balkon]) { echo " \n"; } else { echo "\n"; } if ('1' == $nt[Terrasse]) { echo " \n"; } else { echo "\n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if ('1' == $nt[Garten]) { echo " \n"; } else { echo "\n"; } if ('1' == $nt[Garage]) { echo " \n"; } else { echo "\n"; } echo " \n"; echo " \n"; echo " \n"; if (('Einzelhandel - Kauf' == $nt[O_TYP]) OR ('Industrie - Kauf' == $nt[O_TYP])) { echo " \n"; } else { echo " \n"; } if ('1' == $nt[StellPl]) { echo " \n"; } else { echo "\n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "
 ZimmerNutzflächeKaltmiete /
Kaufpreis		Ausstattung
 
$link
$link$nt[Kurz]
\"Balkon\" \"Terrasse\" 
$nt[Zimmer]$nt[WohnF] m²$nt[Mkalt] €\"Garten\" \"Garage\" 
$nt[Ort]KaufMiete\"Balkon\" 
\n"; } else { include "inhalte/gewerbe/bpobj.php"; } ?>