'V' and publication.type<>'D'"); endif; if ($db==2): $rule = addAnd($rule, "publication.type='J'"); endif; if ($db==3): $rule = addAnd($rule, "publication.type='B'"); endif; if ($db==4): $rule = addAnd($rule, "publication.type='V'"); /* $rule = addAnd($rule, "vortrag.ausland=0"); $rule = addAnd($rule, "publication.id=vortrag.id"); $from = "publication,vortrag"; */ endif; if ($db==5): $rule = addAnd($rule, "publication.type='V'"); $rule = addAnd($rule, "vortrag.beitrag=1"); $rule = addAnd($rule, "publication.id=vortrag.id"); $from = "publication,vortrag"; endif; if ($db==6): $rule = addAnd($rule, "publication.type='V'"); $rule = addAnd($rule, "vortrag.beitrag=2"); $rule = addAnd($rule, "publication.id=vortrag.id"); $from = "publication,vortrag"; endif; if ($db==7): $rule = addAnd($rule, "publication.type='V'"); $rule = addAnd($rule, "vortrag.beitrag=3"); $rule = addAnd($rule, "publication.id=vortrag.id"); $from = "publication,vortrag"; endif; if ($db==8): $rule = addAnd($rule, "publication.type='D'"); $rule = addAnd($rule, "diplom.diplom='Master'"); $rule = addAnd($rule, "publication.id=diplom.id"); $from = "publication,diplom"; endif; if ($db==9): $rule = addAnd($rule, "publication.type='D'"); $rule = addAnd($rule, "diplom.diplom='PhD'"); $rule = addAnd($rule, "publication.id=diplom.id"); $from = "publication,diplom"; endif; $o = "publication.firstname,publication.title"; #echo "SELECT $selects FROM $from $rule ORDER BY $o"; $result = mysql_query("SELECT $selects FROM $from $rule ORDER BY $o"); $nhit = mysql_num_rows($result); if ($l==1): # $tmpfile=tempnam("/tmp","db"); $tmpfile="/tmp/db_$REMOTE_HOST"; $fm = fopen($tmpfile,"w"); echo "
Results are also written in LaTeX style to file:
"; echo "file://tph.tuwien.ac.at/tmp/mysql2latex.txt

"; endif; $i=0; echo "
"; while ($i<$nhit): ?>
[] &db=publication"> "; endif?>
">

, , - , ()
Type: Journal / ao.Dot = / Peer Review = . "", , , , p. - p.
Type: Buchbeitrag / ao.Dot = / Peer Review = . , , , . .
Type: Vortrag / ao.Dot = Betreuer:
.
Type: Diplomarbeit Dissertation Kein Label!"; else: echo "Label: "; echo mysql_result($result,$i,"publication.label"); endif; endif; /* endif; */ echo "

"; $i++; endwhile?>