Dissertationen Online

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

\n"; echo "
"; $name = mysql_result($res,$i,"name"); echo "",$name,"\n"; echo ""; echo ""; $id = mysql_result($res,$i,"id"); $query = "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.workgroup=".$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"; $res2 = mysql_db_query("dissonline",$query); $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(); ?>


 

  Zur Startseite von Dissertationen Online   Zur Homepage der Arbeitsgruppe von Prof. Gasteiger  


dissertationen@ccc.chemie.uni-erlangen.de
Last changed Aug-18-1999