Areas
";
$result = mysql_query("select codigo_area_pesquisa,nome_us from area_pesquisa order by nome_pt",$con);
$result3 = mysql_query("select codigo_area_pesquisa from publicacao_area_pesquisa where codigo_publicacao ='$pub[0]';",$con);
$result4 = mysql_query("select codigo_sub_area_pesquisa from publicacao_sub_area_pesquisa where codigo_publicacao ='$pub[0]';",$con);
while($linha=mysql_fetch_row($result)){
$area = false;
for($j = 0; $j < mysql_num_rows($result3); $j++)
{
if($linha[0] == mysql_result($result3,$j,0))
{
printf("");
$area = true;
}
}
if(!$area)
printf("");
$result2 = mysql_query("select codigo_sub_area_pesquisa,nome_us from sub_area_pesquisa where codigo_area_pesquisa = '$linha[0]'",$con);
while($linha2=mysql_fetch_row($result2))
{
$sub = false;
for($j = 0; $j < mysql_num_rows($result4); $j++)
{
if($linha2[0] == mysql_result($result4,$j,0))
{
printf("");
$sub = true;
}
}
if(!$sub)
printf("");
}
}
echo "";
?>
Publications Type
";
printf("");
while($linha=mysql_fetch_row($result)){
if($linha[0] == $pub[12])
printf("");
else
printf("");
}
echo "";
?>
Author
";
printf("");
while($linha= mysql_fetch_row($result))
{
printf("");
}
echo "";
?>
Published in
";
printf("");
while($linha=mysql_fetch_row($result)){
printf("");
}
echo "";
?>
Date - Show articles published between
Português
English
