|
Publications
";
$x=0;
while ($sql=mysql_fetch_array($result))
{
if ($x == 0){
$anno=$sql["Anno"];
if ($sql["Anno"] == 0)
echo "Next Publication";
else
echo " ". $anno ."";
$x=1;
}
else
{
if ($anno != $sql["Anno"])
{
$anno=$sql["Anno"];
if ($sql["Anno"] == 0)
echo "Next Publication";
else
echo " ". $anno ."";
}
}
$pub_id=$sql["pub_id"];
echo " ". htmlspecialchars($sql["autori"]) .".\n";
echo htmlspecialchars($sql["titolo"]) .".\n";
if ( $sql["titolo_rivista_convegno"] != "" )
{
echo htmlspecialchars($sql["titolo_rivista_convegno"]) ."";
if (( $sql["Volume"] != "" and $sql["Volume"] != "0") || ( $sql["Numero"] != 0 ) ||( $sql["Pagine"] != 0 ) || ( $sql["casa_editrice"] != "" ) || ( $sql["Anno"] != 0 ))
echo ", ";
else
echo ". ";
}
$sql_strng="select wp.wp wp from PUB_TO_WORK,wp where wp.id=PUB_TO_WORK.id_wkp and PUB_TO_WORK.id_pub=". $sql[pub_id] .";";
$rr=mysql_query($sql_strng);
$ind=0;
while ($qwp=mysql_fetch_array($rr))
{
if ($ind > 0) echo ", ";
echo $qwp["wp"];
$ind++;
}
if ( $sql["Volume"] != "" and $sql["Volume"] != "0")
{
echo " vol. ". htmlspecialchars(trim($sql["Volume"])) ."";
if (( $sql["Numero"] != 0 ) ||( $sql["Pagine"] != 0 ) || ( $sql["casa_editrice"] != "" ) || ( $sql["Anno"] != 0 ))
echo ", ";
else
echo ". ";
}
if ( $sql["Numero"] != 0 )
{
echo " nn. ". htmlspecialchars($sql["Numero"]) ."";
if (( $sql["Pagine"] != 0 ) || ( $sql["casa_editrice"] != "" ) || ( $sql["Anno"] != 0 ))
echo ", ";
else
echo ". ";
}
if ( $sql["Pagine"] != 0 )
{
echo " pp. ". htmlspecialchars(trim($sql["Pagine"])) ."";
if (( $sql["casa_editrice"] != "" ) || ( $sql["Anno"] != 0 ))
echo ", ";
else
echo ". ";
}
if ( $sql["casa_editrice"] != "" )
{
echo htmlspecialchars($sql["casa_editrice"]) ."";
if (( $sql["Anno"] != 0 ))
echo ", ";
else
echo ". ";
}
if ( $sql["Anno"] != 0 )
echo " ". htmlspecialchars($sql["Anno"]) .".\n";
if ( $sql["link"] != "" )
echo " [". htmlspecialchars($sql["link"]) ."]\n";
$sql_strng='select * from file_upload where valido=\'S\' and id_tipo=2 AND id_pub='.$pub_id.';';
$ff=mysql_query($sql_strng);
$ind=0;
while ($flp=mysql_fetch_array($ff))
{
if ($ind > 0) echo ",";
echo " [". htmlspecialchars(basename($flp["nome"])) ."]\n";
$ind++;
}
if ( $sql["note"] != "" )
echo " ". htmlspecialchars($sql["note"]) .".\n";
echo "";
}
echo "";
?>
|
