ECOPOLIS: L’ultimo numero

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

$output.=”

Numero $alistnids->numero, $alistnids->data Iscr. Registro Tribunale di Padova n. 1920 del 14/12/04 – Direttore Donatella Gasperi

“;

/////////// recupero 2^ nodo /////////////////
$result1 = db_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 = db_query(“SELECT * FROM node WHERE nid=$nodo”);
$anode=db_fetch_object($result2);
$output.=
“

Primo Piano

$anode->title $anode->body

“;

// $output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid2”;}

//////////// recupero 1^ nodo /////////////////
$result1 = db_query(“SELECT * FROM url_alias WHERE dst=’$alistnids->nid1′ “);
if (db_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.=”

Ambiente

$anode->title $anode->body

“;
// $output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid1”;}

//////////// recupero 3^ nodo /////////////////
$result1 = db_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 = db_query(“SELECT * FROM node WHERE nid=$nodo”);
$anode=db_fetch_object($result2);
$output.=
“

Democrazia Urbana

$anode->title $anode->body

“;

// $output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid3”;}

//////////// recupero 4^ nodo /////////////////
$result1 = db_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 = db_query(“SELECT * FROM node WHERE nid=$nodo”);
$anode=db_fetch_object($result2);
$output.=
“

Cemento Che Ride

$anode->title $anode->body

“;
// $output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid4”;}

//////////// recupero 5^ nodo /////////////////
$result1 = db_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 = db_query(“SELECT * FROM node WHERE nid=$nodo”);
$anode=db_fetch_object($result2);
$output.=
“

Media e Messaggi

$anode->title $anode->body

“;
// $output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid5”;}

//////////// recupero 6^ nodo /////////////////
$result1 = db_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 = db_query(“SELECT * FROM node WHERE nid=$nodo”);
$anode=db_fetch_object($result2);
$output.=
“

Succede in Citta’

$anode->title $anode->body

“;
// $output.= theme(‘node’,$anode);
} else {echo “problemi nel trovare $alistnids->nid6″;}

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

return $output;
?>