$result1 = mysql_query("SELECT * FROM {$table1} WHERE id = '{$id}'");
 echo mysql_error();
 $titel = mysql_result($result1, isset($i1), 'titel');
 $vorname = mysql_result($result1, isset($i1), 'vorname');
 $name = mysql_result($result1, isset($i1), 'name');
 $u_name = mysql_result($result1, isset($i1), 'username');
 $strasse = mysql_result($result1, isset($i1), 'strasse');
 $plz = mysql_result($result1, isset($i1), 'plz');
 $ort = mysql_result($result1, isset($i1), 'ort');
 $tel = mysql_result($result1, isset($i1), 'tel');
 $email = mysql_result($result1, isset($i1), 'email');
 $internet = mysql_result($result1, isset($i1), 'internet');
 $language = mysql_result($result1, isset($i1), 'language');
 $direkt_download = mysql_result($result1, isset($i1), 'direkt_download');
 echo "\n\t<div class='page'>\n\t\n\t\t<p id='kopf'>pic2base :: Benutzerdaten anpassen <span class='klein'>(User: {$username})</span></p>\n\t\t\t\n\t\t<div class='navi' style='clear:right;'>\n\t\t\t<div class='menucontainer'>";
 createNavi5($uid);
 echo "</div>\n\t\t</div>\n\t\t\n\t\t<div id='spalte1'>\n\t\t<p id='elf' style='background-color:white; padding: 5px; margin-top: 4px; margin-left: 0px; text-align:center;'>Pers. Einstellungen f&uuml;r " . $vorname . " " . $name . " (" . $u_name . "):<BR>\n\t\t<FORM name = 'pwd' method = post action = 'save_pwd1.php?mod=all'>\n\t\t<TABLE align=center style='width:90%;border-width:1px;border-color:#DDDDFF;border-style:none;padding:0px;margin-top:6px;margin-bottom:0px;\n\t    \ttext-align:center;'>\n\t\t<TR id='kat' style='height:3px;'>\n\t\t\t<TD class='normal' style='background-color:#ff9900;' colspan = '3'></TD>\n\t\t</TR>\n\t\t\n\t\t<TR id='kat'>\n\t\t\t<TD id='kat1'>Titel:</TD>\n\t\t\t<TD id='kat1' colspan='2'><input type='text' name='titel' value = '{$titel}' style='width:200px;'></TD>\n\t\t</TR>\n\t\t\n\t\t<TR id='kat'>\n\t\t\t<TD id='kat1'>Name:</TD>\n\t\t\t<TD id='kat1' colspan='2'><input type='text' name='name' value = '{$name}' style='width:200px;'></TD>\n\t\t</TR>\n\t\t\n\t\t<TR id='kat'>\n\t\t\t<TD id='kat1'>Vorname:</TD>\n\t\t\t<TD id='kat1' colspan='2'><input type='text' name='vorname' value = '{$vorname}' style='width:200px;'></TD>\n\t\t</TR>\n\t\t\n\t\t<TR id='kat'>\n\t\t\t<TD id='kat1'>Strasse:</TD>\n\t\t\t<TD id='kat1' colspan='2'><input type='text' name='strasse' value = '{$strasse}' style='width:200px;'></TD>\n\t\t</TR>\n\t\t\n\t\t<TR id='kat'>\n\t\t\t<TD id='kat1'>PLZ:</TD>\n\t\t\t<TD id='kat1' colspan='2'><input type='text' name='plz' value = '{$plz}' style='width:200px;'></TD>\n\t\t</TR>\n\t\t\n\t\t<TR id='kat'>\n\t\t\t<TD id='kat1'>Ort:</TD>\n\t\t\t<TD id='kat1' colspan='2'><input type='text' name='ort' value = '{$ort}' style='width:200px;'></TD>\n\t\t</TR>\n\t\t\n\t\t<TR id='kat'>\n\t\t\t<TD id='kat1'>Telefon:</TD>\n\t\t\t<TD id='kat1' colspan='2'><input type='text' name='tel' value = '{$tel}' style='width:200px;'></TD>\n\t\t</TR>\n\t\t\n\t\t<TR id='kat'>\n\t\t\t<TD id='kat1'>eMail:</TD>\n\t\t\t<TD id='kat1' colspan='2'><input type='text' name='email' value = '{$email}' style='width:200px;'></TD>\n\t\t</TR>\n\t\t\n\t\t<TR id='kat'>\n\t\t\t<TD id='kat1'>Internet:</TD>\n\t\t\t<TD id='kat1' colspan='2'><input type='text' name='internet' value = '{$internet}' style='width:200px;'></TD>\n\t\t</TR>\n\t\t\n\t\t<TR id='kat'>\n\t\t\t<TD id='kat1'>Sprache:</TD>\n\t\t\t<TD id='kat1' colspan='2'>\n\t\t\t<SELECT name='language' style='width:200px;'>";
 switch ($language) {
     case 'de':
         $de = 'selected';
         break;
     case 'en':
         $en = 'selected';
         break;
     case 'ru':
         $ru = 'selected';
         break;
     case 'cs':
         $cs = 'selected';
         break;
     case 'es':
 *
 * Project owner:
 * Dipl.-Ing. Klaus Henneberg
 * 38889 Blankenburg, BRD
 *
 * This file is licensed under the terms of the Open Software License
 * http://www.opensource.org/licenses/osl-2.1.php
 *
 * @copyright 2003-2008 Klaus Henneberg
 * @author Klaus Henneberg
 * @package pic2base
 * @license http://www.opensource.org/licenses/osl-2.1.php Open Software License
 */
unset($username);
if ($_COOKIE['login']) {
    list($c_username) = split(',', $_COOKIE['login']);
    //echo $c_username;
}
include '../../share/global_config.php';
include $sr . '/bin/share/db_connect1.php';
include $sr . '/bin/share/functions/ajax_functions.php';
include $sr . '/bin/share/functions/main_functions.php';
echo "\n<div class='page'>\n\n\t<p id='kopf'>pic2base :: Pers&ouml;nliche Einstellungen <span class='klein'>(User: {$c_username})</span></p>\n\t\t\n\t<div class='navi' style='clear:right;'>\n\t\t<div class='menucontainer'>";
createNavi5($c_username);
echo "</div>\n\t</div>\n\t\n\t<div id='spalte1'>\n\t<p id='elf' style='background-color:white; padding: 5px; margin-top: 4px; margin-left: 0px; text-align:center;'>Legen Sie hier Ihre pers&ouml;nlichen Einstellungen fest:<BR>\n\t<FORM name = 'pwd' method = post action = 'save_pwd1.php'>\n\t<TABLE align=center style='width:90%;border-width:1px;border-color:#DDDDFF;border-style:solid;padding:0px;margin-top:6px;margin-bottom:0px;\n    \ttext-align:center;'>\n\t<TR id='kat'>\n\t\t<TD id='kat1' style='background-color:#ff9900;height:10px' colspan = '3'>\n\t\t</TD>\n\t</TR>\n\t\n\t<TR id='kat'>\n\t\t<TD id='kat1' colspan='3'>Passwort &auml;ndern</TD>\n\t</TR>\n\t\n\t<TR id='kat'>\n\t\t<TD id='kat1'>Altes Passwort:</TD>\n\t\t<TD id='kat1' colspan='2'><input type='password' name='old_pwd' style='width:200px;'</TD>\n\t</TR>\n\t\n\t<TR id='kat'>\n\t\t<TD id='kat1'>Neues Passwort:</TD>\n\t\t<TD id='kat1' colspan='2'><input type='password' name='new_pwd_1' style='width:200px;'</TD>\n\t</TR>\n\t\n\t<TR id='kat'>\n\t\t<TD id='kat1'>Passwort wiederholen:</TD>\n\t\t<TD id='kat1' colspan='2'><input type='password' name='new_pwd_2' style='width:200px;'</TD>\n\t</TR>\n\t\n\t<TR id='kat'>\n\t\t<TD id='kat1' colspan='3'></TD>\n\t</TR>\n\t\n\t<TR id='kat'>\n\t\t<TD id='kat1' colspan='3' style='text-align:center;'><INPUT type=\"submit\" value=\"Speichern\" style='margin-right:20px;'><INPUT type=\"button\" value=\"Abbrechen\" onClick=\"javascript:history.back()\"></TD>\n\t</TR>\n\t\n\t<TR id='kat'>\n\t\t<TD id='kat1' style='background-color:#ff9900;height:10px' colspan = '3'>\n\t\t</TD>\n\t</TR>\n\t\n\t</TABLE>\n\t</FORM>\n\t</div>\n\t\n\t<div id='spalte2'>\n\t\n\t</div>\n\n\t<p id='fuss'><A style='margin-right:745px;' HREF='http://www.pic2base.de' target='blank'>www.pic2base.de</A>" . $cr . "</p>\n\n</div>";
mysql_close($conn);
?>
</DIV>
</CENTER>
</BODY>
</HTML>