query($sql1); $i = 1; while ($nt1 = $result1->fetch_assoc()) { if (1 == $i) { echo "

\n"; echo "
• Immobilienvermittlung
\n"; echo "

\n"; echo "

\n"; $i++; } echo "
• \n"; echo " ".$nt1['Name']."\n"; echo "
\n"; } if (1 !== $i) { echo "
• \n"; echo " Gewerbe Objekte\n"; echo "
\n"; echo "

\n"; } $sql3 = 'SELECT Kurz, Name FROM US WHERE Wert = "on" AND Sektion = "verwaltung" ORDER BY ID ASC'; $result3 = $db->query($sql3); $i = 0; while ($nt3 = $result3->fetch_assoc()) { if (0 == $i) { echo "

\n"; echo "
• Immobilienverwaltung
\n"; echo "

\n"; echo "

\n"; $i++; } echo "
• \n"; echo " ".$nt3['Name']."\n"; echo "
\n"; } echo "

\n"; $sql4 = 'SELECT Kurz, Name FROM US WHERE Wert = "on" AND Sektion = "unter" ORDER BY ID ASC'; $result4 = $db->query($sql4); $i = 0; while ($nt4 = $result4->fetch_assoc()) { if (0 == $i) { echo "

\n"; echo "
• Das Unternehmen
\n"; echo "

\n"; echo "

\n"; $i++; } echo "
• \n"; echo " ".$nt4['Name']."\n"; echo "
\n"; } echo "

\n"; ?>