Dissertationen Online
Betreuer

"; 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",mysql_result($res2,$j,"firstname")," ",mysql_result($res2,$j,"familyname"),""; echo ": (",mysql_result($res2,$j,"doctype"),")\n"; echo "
"; $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