| Dissertationen Online Institute mysql_connect("zabib"); $res = mysql_db_query("dissonline","select * from institutes order by name"); $num = mysql_num_rows($res); echo $num," Institute sind derzeit gespeichert: "; $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 "; $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(); ?> |
include('footer.html'); ?>
dissertationen@ccc.chemie.uni-erlangen.de Template last changed 2000-01-04