@mysql_connect("localhost","wwwuser","$dbpassword") or die("Connection died or wrong database password!"); mysql_select_db("e136") ; $rule = "where id=$projekt_id"; /* THAT IS THE special RULE here */ $pagetitle = "Mitarbeiterdaten modifizieren"; $pageheadline = $pagetitle; include "../e136header.phtml"?> Projekt:
$result = mysql_query("select * from stammprojekt $rule"); $leiter = mysql_result($result,0,"leiter"); $geldgeber = mysql_result($result,0,"geldgeber"); $title = mysql_result($result,0,"title"); $nr = mysql_result($result,0,"nr"); $subresult = mysql_query("select * from projektinfo $rule"); ?>
| Projekt-Titel: | echo $title?> |
| Geldgeber: | echo $geldgeber?> |
| Projekt-Nummer: | echo $nr?> |
| Projekt-Leiter: | echo $leiter?> |
| Projekt-Zusage: | echo mysql_result($subresult,0,"z_tag")?>. echo mysql_result($subresult,0,"z_monat")?>. echo mysql_result($subresult,0,"z_jahr")?> |
| Projekt-Beginn: | echo mysql_result($subresult,0,"b_tag")?>. echo mysql_result($subresult,0,"b_monat")?>. echo mysql_result($subresult,0,"b_jahr")?> |
$result = mysql_query("select vorname,nachname from stammmitarbeiter where id=$id")?>
$result=mysql_query("select * from mitarbeiterinfo where mit_id=$id"); $nhit=mysql_num_rows($result); $i=0; echo "