query($sql);
$nt = $result->fetch_assoc();
$sql1 = "SELECT * FROM Firma WHERE ID='2' ";
$result1= $db->query($sql1);
$nt1 = $result1->fetch_assoc();
$sql2 = "SELECT Kurz FROM US WHERE Sektion = \"kontakt\" AND Wert = \"on\" ORDER BY ID ASC;";
$result2= $db->query($sql2);
echo "".$nt['Titel']."
\n";
if ("ohne" == $nt['Foto_Layout']) {
} elseif ("rechts" == $nt['Foto_Layout']) {
echo "![\"".$nt['Titel']."\"](\"img/team/ko.jpg\" "\\"\".$nt['Titel'].\"\\"")
\n";
} elseif ("links" == $nt['Foto_Layout']) {
echo "\n";
} elseif ("oben" == $nt['Foto_Layout']) {
echo "\n";
echo " ![\"".$nt['Titel']."\"](\"img/team/ko_oben.jpg\" "\\"\".$nt['Titel'].\"\\"")
\n";
echo "
\n";
}
echo "".nl2br($nt['Text'])."
\n";
echo "".$nt1['Firma']."
\n";
if ('' !== $nt1['Vertreter1']) {
echo $nt1['Vertreter1'];
}
if ('' !== $nt1['Vertreter2']) {
echo ", ".$nt1['Vertreter2'];
}
if ('' !== $nt1['Vertreter3']) {
echo ", ".$nt1['Vertreter3']."\n";
}
echo "
\n";
echo "\n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " \n";
echo " ".$nt1['Strasse']." ".$nt1['HausNr']."
".$nt1['PLZ']." ".$nt1['Ort']."
".$nt1['Land']."
| \n";
echo "
\n";
echo " \n";
echo " | Tel: | \n";
echo " ".$nt1['Telefon']." | \n";
echo "
\n";
echo " \n";
echo " | Fax: | \n";
echo " ".$nt1['Telefax']." | \n";
echo "
\n";
echo " \n";
echo " | Email: | \n";
echo " " . $nt1['EMail'] . " | \n";
echo "
\n";
echo "
\n";
echo "
\n";
if (("links" == $nt['Foto_Layout']) OR ("rechts" == $nt['Foto_Layout'])) {
echo "
\n";
echo "
\n";
}
while ($nt2 = $result2->fetch_assoc()) {
if ("ii" == $nt2['Kurz']) {
echo "Ich suche eine Immobilie und möchte das Interessentenformular nutzen.
\n";
} elseif ("vv" == $nt2['Kurz']) {
echo "Ich bin Vermieter / Verkäufer und möchte das Vermieterformular nutzen.
\n";
}
}
?>