@mysql_connect("localhost","wwwe136adm","$admpassword") or die("Connection died or wrong supervisor password!"); mysql_select_db("e136") ; $rule = "where id=$id"; /* THAT IS THE GENERAL RULE */ $pagetitle = "Karenzierung Eingeben"; $pageheadline = $pagetitle; include "../e136header.phtml"; $result = mysql_query("select * from stammpersonen $rule"); $vorname = mysql_result($result,0,"vorname"); $nachname = mysql_result($result,0,"nachname"); $subresult = mysql_query("select * from personeninfo $rule"); $dienst = mysql_result($subresult,0,"dienst"); $prozent = mysql_result($subresult,0,"prozent"); $v_tag = mysql_result($subresult,0,"v_tag"); $v_monat = mysql_result($subresult,0,"v_monat"); $v_jahr = mysql_result($subresult,0,"v_jahr"); $b_tag = mysql_result($subresult,0,"b_tag"); $b_monat = mysql_result($subresult,0,"b_monat"); $b_jahr = mysql_result($subresult,0,"b_jahr"); ?> Permanenter Posten:
Vorname: echo $vorname?>
Nachname: echo $nachname?>
Dienstverhältnis: if ($dienst==1): echo "unbefristet
"; endif; if ($dienst==0): ?> echo "befristet von"?> echo $v_tag?>. echo $v_monat?>. echo $v_jahr?> bis echo $b_tag?>. echo $b_monat?>. echo $b_jahr?>
endif?>