ECOPOLIS: legge ultimo numero

mdata’ “; // trova ultima data
$result = mysql_query($sql);
$alistnids = db_fetch_object($result); // raccoglie tutti i nodi

$output.=”

Numero $alistnids->numero del $alistnids->data

“;

//////////// recupero 1^ nodo /////////////////
$result1 = mysql_query(“SELECT * FROM url_alias WHERE dst=’$alistnids->nid1′ “);
if (mysql_num_rows($result1)!=0) {
$asrc=db_fetch_object($result1);
$nodo=substr($asrc->src,5);
// recupera il nodo con il nid trovato
$result2 = db_query(“SELECT * FROM node WHERE nid=$nodo”);
$anode=db_fetch_object($result2);
$output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid1”;}

//////////// recupero 2^ nodo /////////////////
$result1 = mysql_query(“SELECT * FROM url_alias WHERE dst=’$alistnids->nid2′ “);
if (db_num_rows($result1)!=0) {
$asrc=db_fetch_object($result1);
$nodo=substr($asrc->src,5);
// recupera il nodo con il nid trovato
$result2 = mysql_query(“SELECT * FROM node WHERE nid=$nodo”);
$anode=db_fetch_object($result2);
$output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid2”;}

//////////// recupero 3^ nodo /////////////////
$result1 = mysql_query(“SELECT * FROM url_alias WHERE dst=’$alistnids->nid3′ “);
if (db_num_rows($result1)!=0) {
$asrc=db_fetch_object($result1);
$nodo=substr($asrc->src,5);
// recupera il nodo con il nid trovato
$result2 = mysql_query(“SELECT * FROM node WHERE nid=$nodo”);
$anode=db_fetch_object($result2);
$output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid3”;}

//////////// recupero 4^ nodo /////////////////
$result1 = mysql_query(“SELECT * FROM url_alias WHERE dst=’$alistnids->nid4′ “);
if (db_num_rows($result1)!=0) {
$asrc=db_fetch_object($result1);
$nodo=substr($asrc->src,5);
// recupera il nodo con il nid trovato
$result2 = mysql_query(“SELECT * FROM node WHERE nid=$nodo”);
$anode=db_fetch_object($result2);
$output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid4”;}

//////////// recupero 5^ nodo /////////////////
$result1 = mysql_query(“SELECT * FROM url_alias WHERE dst=’$alistnids->nid5′ “);
if (db_num_rows($result1)!=0) {
$asrc=db_fetch_object($result1);
$nodo=substr($asrc->src,5);
// recupera il nodo con il nid trovato
$result2 = mysql_query(“SELECT * FROM node WHERE nid=$nodo”);
$anode=db_fetch_object($result2);
$output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid5”;}

//////////// recupero 6^ nodo /////////////////
$result1 = mysql_query(“SELECT * FROM url_alias WHERE dst=’$alistnids->nid6′ “);
if (db_num_rows($result1)!=0) {
$asrc=db_fetch_object($result1);
$nodo=substr($asrc->src,5);
// recupera il nodo con il nid trovato
$result2 = mysql_query(“SELECT * FROM node WHERE nid=$nodo”);
$anode=db_fetch_object($result2);
$output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid6″;}

} else {
$output=”data max non trovata”;
}

return $output;
?>