| Dissertationen Online Betreuer mysql_connect("zabib"); $res = mysql_db_query("dissonline","select * from advisors where is_advisor = 1 order by familyname"); $num = mysql_num_rows($res); echo $num," Betreuer sind derzeit gespeichert: "; for ($i=0;$i<$num;$i++) { $homepage = mysql_result($res,$i,"homepage"); echo " "; echo " ";
$name = mysql_result($res,$i,"title")." ".mysql_result($res,$i,"firstname") . " " . mysql_result($res,$i,"familyname");
echo "",$name,"\n";
echo " | ";
$id = mysql_result($res,$i,"id");
$res2 = mysql_db_query("dissonline","select d.title_d,d.htmlurl,d.doctype,a.id,a.familyname,a.firstname from authors a, documents d where d.authorid = a.id and d.status='Abgeschlossen' and (d.advisor1 = ".$id." or d.advisor2 = ".$id." or d.advisor3 = ".$id." or d.advisor4 = ".$id.") order by a.familyname");
for ($j=0;$j | "; $htmlurl = mysql_result($res2,$j,"htmlurl"); if ($htmlurl!="") { echo "",mysql_result($res2,$j,"title_d"),""; } else { echo mysql_result($res2,$j,"title"); } echo " "; } if (mysql_num_rows($res2)==0) { echo "(keine)"; } } mysql_close(); ?> |
dissertationen@ccc.chemie.uni-erlangen.de Template last changed 2000-04-01