eccolo!!!
Codice PHP:
<textarea style="width:500px; height:100px;">
<?
$query = "SELECT * FROM scadenze WHERE data > now()";
$result = mysql_query($query, $db);
while($row = mysql_fetch_array($result)){
$data=$row['data'];
$mir=substr($row["testo"],0,80);
$mir=$mir."...";
$dayOLD = substr($data, 8, 2);
$monthOLD = substr($data, 5, 2);
$yearOLD = substr($data, 0, 4);
echo"[b]$row[titolo][/b]
<a href=\"./php/link_scad.php?id=$row[id]\">$mir</a>
"."Scade il: [b] $dayOLD/$monthOLD/$yearOLD [/b]
";
}
echo"</textarea>";