Dissertationen Online
Institute

"; $i=0; while ($i<$num) { $homepage = mysql_result($res,$i,"homepage"); echo "


\n"; echo "
"; $name = mysql_result($res,$i,"name"); $id = mysql_result($res,$i,"id"); $orgid = mysql_result($res,$i,"institution"); $res2 = mysql_db_query("dissonline","select name from institutions where id = ".$orgid); $org = mysql_result($res2,0,"name"); echo "",$name,"
"; $partid = mysql_result($res,$i,"partof"); if ($partid!="" && $partid!=0) { $res3 = mysql_db_query("dissonline","select name from institutes where id =".$partid); echo "(organizational unit of ",mysql_result($res3,0,"name"),")
"; } echo "$org\n"; echo "
"; $res2 = mysql_db_query("dissonline","select distinct a.id,a.firstname,a.familyname,d.title_d,d.htmlurl,d.doctype from authors a, advisors x, documents d where d.authorid = a.id and x.institute=".$id." and d.status='Abgeschlossen' and (d.advisor1=x.id or d.advisor2=x.id or d.advisor3=x.id or d.advisor4=x.id) order by a.familyname"); $j = 0; while ($j",mysql_result($res2,$j,"firstname")," ",mysql_result($res2,$j,"familyname"),"";; echo ": (",mysql_result($res2,$j,"doctype"),")
"; $htmlurl = mysql_result($res2,$j,"htmlurl"); if ($htmlurl!="") { echo "",mysql_result($res2,$j,"title_d"),""; } else { echo mysql_result($res2,$j,"title_d"); } echo "

"; $j++; } if (mysql_num_rows($res2)==0) { echo "(keine)"; } $i++; } mysql_close(); ?>



dissertationen@ccc.chemie.uni-erlangen.de
Template last changed 2000-01-04