Codice PHP:
$query = "SELECT id_news, titolo_news, DATE_FORMAT(data_news, \"%d/%m/%Y\") AS data FROM news ORDER BY id_news DESC LIMIT 8";
$results = mysql_query($query) or die ("Errore 1: " . mysql_error());
while ($row = mysql_fetch_assoc($results)) {
echo "<a href=\"index.php?id_news=$row[id]\">" . $row['titolo_news'] . " - " . $row['data'] . "</a>
";
}