Connessione al database fallita";
exit;
}
$db = mysql_select_db("ongarda", $dblink);
if(!$db) {
echo "Impossibile aprire il database 'ONGARDA'";
exit;
}
$querynumrecords = mysql_db_query("ongarda", "select * from notizie");
$records = mysql_num_rows($querynumrecords);
$metarecords = round($records / 2);
mysql_free_result($querynumrecords);
$query = mysql_db_query("ongarda", "select * from notizie order by data desc");
while($row = mysql_fetch_array($query)) {
$datapiena=$row["data"];
$solodata= substr ($datapiena, 0, 10);
$data_americana = explode("-", $solodata);
$data_europea = $data_americana[2].".".$data_americana[1];
$cod = $row["codice"];
echo $data_europea;
echo " ";
echo $row["titolo"];
echo "";
echo " ";
$counter = $counter+1;
if ($counter == $metarecords)
echo " | ";
}
mysql_free_result($query);
mysql_close ($dblink);
?>
|