Gewerbeimmobilien\n"; echo "

\n"; echo " Sortierung nach\n"; echo " \n"; echo " Objekt-ID aufsteigend\n"; echo " Objekt-ID absteigend\n"; echo " Mitarbeiter aufsteigend\n"; echo " Mitarbeiter absteigend\n"; echo " Wohnfläche aufsteigend\n"; echo " Wohnfläche absteigend\n"; echo " Kaltmiete / Kaufpreis aufsteigend\n"; echo " Kaltmiete / Kaufpreis absteigend\n"; echo " Erstelldatum aufsteigend\n"; echo " Erstelldatum absteigend\n"; echo " Änderungsdatum aufsteigend\n"; echo " Änderungsdatum absteigend\n"; echo " Homepage-Zugriffe aufsteigend\n"; echo " Homepage-Zugriffe absteigend\n"; echo " \n"; echo "
\n"; echo "  \n"; echo " \n"; echo "

\n"; if (isset($_POST['action'])) { $order = ", ".$_POST['Sortierung']; } // Wohnimmobilien - Abfrage $sql1 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Büro\" OR O_TYP = \"Praxis\") AND V_TYP = \"Miete\" AND Aktiv = \"1\" ORDER BY O_TYP ASC".$order.";"; $result1 = $db->query($sql1); $sql2 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Büro\" OR O_TYP = \"Praxis\") AND V_TYP = \"Miete\" AND Aktiv = \"0\" ORDER BY O_TYP ASC".$order.";"; $result2 = $db->query($sql2); $sql3 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Büro\" OR O_TYP = \"Praxis\") AND V_TYP = \"Kauf\" AND Aktiv = \"1\" ORDER BY O_TYP ASC".$order.";"; $result3 = $db->query($sql3); $sql4 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Büro\" OR O_TYP = \"Praxis\") AND V_TYP = \"Kauf\" AND Aktiv = \"0\" ORDER BY O_TYP ASC".$order.";"; $result4 = $db->query($sql4); $sql5 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Einzelhandel\" OR O_TYP = \"Industrie\") AND V_TYP = \"Miete\" AND Aktiv = \"1\" ORDER BY O_TYP ASC".$order.";"; $result5 = $db->query($sql5); $sql6 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Einzelhandel\" OR O_TYP = \"Industrie\") AND V_TYP = \"Miete\" AND Aktiv = \"0\" ORDER BY O_TYP ASC".$order.";"; $result6 = $db->query($sql6); $sql7 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Einzelhandel\" OR O_TYP = \"Industrie\") AND V_TYP = \"Kauf\" AND Aktiv = \"1\" ORDER BY O_TYP ASC".$order.";"; $result7 = $db->query($sql7); $sql8 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Einzelhandel\" OR O_TYP = \"Industrie\") AND V_TYP = \"Kauf\" AND Aktiv = \"0\" ORDER BY O_TYP ASC".$order.";"; $result8 = $db->query($sql8); $sql9 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Gastronomie\" OR O_TYP = \"Hotel\") AND V_TYP = \"Miete\" AND Aktiv = \"1\" ORDER BY O_TYP ASC".$order.";"; $result9 = $db->query($sql9); $sql10 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Gastronomie\" OR O_TYP = \"Hotel\") AND V_TYP = \"Miete\" AND Aktiv = \"0\" ORDER BY O_TYP ASC".$order.";"; $result10 = $db->query($sql10); $sql11 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Gastronomie\" OR O_TYP = \"Hotel\") AND V_TYP = \"Kauf\" AND Aktiv = \"1\" ORDER BY O_TYP ASC".$order.";"; $result11 = $db->query($sql11); $sql12 = "SELECT ID, TID, Kurz, Art, WohnF, Mkalt, Count, DATE_FORMAT(Datum, \"%d.%m.%Y\") AS Datum, DATE_FORMAT(Akt_Datum, \"%d.%m.%Y\") AS Akt_Datum FROM objekte WHERE (O_TYP = \"Gastronomie\" OR O_TYP = \"Hotel\") AND V_TYP = \"Kauf\" AND Aktiv = \"0\" ORDER BY O_TYP ASC".$order.";"; $result12 = $db->query($sql12); 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($bpma = $result1->fetch_assoc()) { 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($bpka = $result3->fetch_assoc()) { 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($eima = $result5->fetch_assoc()) { 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($eika = $result7->fetch_assoc()) { 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($ghma = $result9->fetch_assoc()) { 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($ghka = $result11->fetch_assoc()) { 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($bpmi = $result2->fetch_assoc()) { 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($bpki = $result2->fetch_assoc()) { 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($eimi = $result6->fetch_assoc()) { 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($eiki = $result8->fetch_assoc()) { 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($ghmi = $result10->fetch_assoc()) { 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"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($ghki = $result12->fetch_assoc()) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "

aktive Gewerbeimmobilien
Büros / Praxen - Miete
ID	TID	Kurzbeschreibung	Typ	Fläche	KM	Erstellt	Geändert	Zugriffe
".$bpma['ID']."	".$bpma['TID']."	".substr($bpma['Kurz'],0,30)."	".$bpma['Art']."	".$bpma['WohnF']." qm	".$bpma['Mkalt']." €	".$bpma['Datum']."	".$bpma['Akt_Datum']."	".$bpma['Count']."
Büros / Praxen - Kauf
ID	TID	Kurzbeschreibung	Typ	Fläche	KP	Erstellt	Geändert	Zugriffe
".$bpka['ID']."	".$bpka['TID']."	".substr($bpka['Kurz'],0,30)."	".$bpka['Art']."	".$bpka['WohnF']." qm	".$bpka['Mkalt']." €	".$bpka['Datum']."	".$bpka['Akt_Datum']."	".$bpka['Count']."
Einzelhandel / Industrie - Miete
ID	TID	Kurzbeschreibung	Typ	Fläche	KM	Erstellt	Geändert	Zugriffe
".$eima['ID']."	".$eima['TID']."	".substr($eima['Kurz'],0,30)."	".$eima['Art']."	".$eima['WohnF']." qm	".$eima['Mkalt']." €	".$eima['Datum']."	".$eima['Akt_Datum']."	".$eima['Count']."
Einzelhandel / Industrie - Kauf
ID	TID	Kurzbeschreibung	Typ	Fläche	KP	Erstellt	Geändert	Zugriffe
".$eika['ID']."	".$eika['TID']."	".substr($eika['Kurz'],0,30)."	".$eika['Art']."	".$eika['WohnF']." qm	".$eika['Mkalt']." €	".$eika['Datum']."	".$eika['Akt_Datum']."	".$eika['Count']."
Gastronomie / Hotels - Miete
ID	TID	Kurzbeschreibung	Typ	Fläche	KM	Erstellt	Geändert	Zugriffe
".$ghma['ID']."	".$ghma['TID']."	".substr($ghma['Kurz'],0,30)."	".$ghma['Art']."	".$ghma['WohnF']." qm	".$ghma['Mkalt']." €	".$ghma['Datum']."	".$ghma['Akt_Datum']."	".$ghma['Count']."
Gastronomie / Hotels - Kauf
ID	TID	Kurzbeschreibung	Typ	Fläche	KP	Erstellt	Geändert	Zugriffe
".$ghka['ID']."	".$ghka['TID']."	".substr($ghka['Kurz'],0,30)."	".$ghka['Art']."	".$ghka['WohnF']." qm	".$ghka['Mkalt']." €	".$ghka['Datum']."	".$ghka['Akt_Datum']."	".$ghka['Count']."
inaktive Gewerbeimmobilien
Büros / Praxen - Miete
ID	TID	Kurzbeschreibung	Typ	Fläche	KM	Erstellt	Geändert	Zugriffe
".$bpmi['ID']."	".$bpmi['TID']."	".substr($bpmi['Kurz'],0,30)."	".$bpmi['Art']."	".$bpmi['WohnF']." qm	".$bpmi['Mkalt']." €	".$bpmi['Datum']."	".$bpmi['Akt_Datum']."	".$bpmi['Count']."
Büros / Praxen - Kauf
ID	TID	Kurzbeschreibung	Typ	Fläche	KP	Erstellt	Geändert	Zugriffe
".$bpki['ID']."	".$bpki['TID']."	".substr($bpki['Kurz'],0,30)."	".$bpki['Art']."	".$bpki['WohnF']." qm	".$bpki['Mkalt']." €	".$bpki['Datum']."	".$bpki['Akt_Datum']."	".$bpki['Count']."
Einzelhandel / Industrie - Miete
ID	TID	Kurzbeschreibung	Typ	Fläche	KM	Erstellt	Geändert	Zugriffe
".$eimi['ID']."	".$eimi['TID']."	".substr($eimi['Kurz'],0,30)."	".$eimi['Art']."	".$eimi['WohnF']." qm	".$eimi['Mkalt']." €	".$eimi['Datum']."	".$eimi['Akt_Datum']."	".$eimi['Count']."
Einzelhandel / Industrie - Kauf
ID	TID	Kurzbeschreibung	Typ	Fläche	KP	Erstellt	Geändert	Zugriffe
".$eiki['ID']."	".$eiki['TID']."	".substr($eiki['Kurz'],0,30)."	".$eiki['Art']."	".$eiki['WohnF']." qm	".$eiki['Mkalt']." €	".$eiki['Datum']."	".$eiki['Akt_Datum']."	".$eiki['Count']."
Gastronomie / Hotels - Miete
ID	TID	Kurzbeschreibung	Typ	Fläche	KM	Erstellt	Geändert	Zugriffe
".$ghmi['ID']."	".$ghmi['TID']."	".substr($ghmi['Kurz'],0,30)."	".$ghmi['Art']."	".$ghmi['WohnF']." qm	".$ghmi['Mkalt']." €	".$ghmi['Datum']."	".$ghmi['Akt_Datum']."	".$ghmi['Count']."
Gastronomie / Hotels - Kauf
ID	TID	Kurzbeschreibung	Typ	Fläche	KP	Erstellt	Geändert	Zugriffe
".$ghki['ID']."	".$ghki['TID']."	".substr($ghki['Kurz'],0,30)."	".$ghki['Art']."	".$ghki['WohnF']." qm	".$ghki['Mkalt']." €	".$ghki['Datum']."	".$ghki['Akt_Datum']."	".$ghki['Count']."

\n"; } ?>