<?
 mysql_connect("localhost","eventi","eventidb");
 $result = mysql_db_query("Eventi","select * from annunci WHERE NOW() BETWEEN data_inizio AND data_fine");
 $num_rows = mysql_numrows($result);
 if ($num_rows == 0) {echo "nessun annuncio\n";}else{
 while($row=mysql_fetch_row($result)){
   echo "<FONT FACE=\"verdana,arial,sans-serif\" SIZE=\"2\"><DL><DT><B><a href=".$row[5].">".$row[3]."</a></b><dd>".$row[4]."</dl></font>\n";
   }
   }
 ?>
