query($sql); $nt = $result->fetch_assoc(); $sql2 = 'SELECT Vorname, Nachname FROM Team WHERE ID = "'.$nt['TID'].'";'; $result2 = $db->query($sql2); $nt2 = $result2->fetch_assoc(); $sql3 = 'SELECT DATE_FORMAT(Datum, "%d.%m.%Y") AS Datum, DATE_FORMAT(Akt_Datum, "%d.%m.%Y") AS Akt_Datum FROM vv WHERE ID = "'.$_POST['ID'].'" '; $result3 = $db->query($sql3); $nt3 = $result3->fetch_assoc(); echo "

".$nt['ID']." - ".$nt['Anrede']." ".$nt['Vorname']." ".$nt['Nachname']."

\n"; echo "

\n"; echo " Aufgenommen:\n"; echo " ".$nt2['Vorname']." ".$nt2['Nachname'].", ".$nt3['Datum']."\n"; echo " Zuletzt bearbeitet:\n"; echo " ".$nt3['Akt_Datum']."\n"; echo "

\n"; echo "

\n"; echo " Kontaktdaten\n"; echo " Anrede\n"; echo " ".$nt['Anrede']."\n"; echo " Telefon\n"; echo " ".$nt['Telefon']."\n"; echo "
\n"; echo " Vorname\n"; echo " ".$nt['Vorname']."\n"; echo " Fax\n"; echo " ".$nt['Fax']."\n"; echo "
\n"; echo " Nachname\n"; echo " ".$nt['Nachname']."\n"; echo " Mobil\n"; echo " ".$nt['Mobil']."\n"; echo "
\n"; echo " Adresse\n"; echo " ".$nt['Adresse']."\n"; echo " Firma\n"; echo " ".$nt['Firma']."\n"; echo "
\n"; echo " PLZ / Ort\n"; echo " ".$nt['PLZ']." ".$nt['Ort']."\n"; echo "
\n"; echo " Email\n"; echo " ".$nt['Email']."\n"; echo "

\n"; echo "

\n"; echo " Sonstiges\n"; echo "

".nl2br($nt['Sonstiges'])."

\n"; echo "

\n"; echo " Interne Infos\n"; echo "

".nl2br($nt['Intern'])."

\n"; echo "

\n"; include "inhalte/personen/vv_obj.php"; } ?>