<?
$database = "flash";
$connessione = mysql_connect("http://www.usuarios.lycos.es","xxxx","xxxx") or die ("server no encontrado")
mysql_select_db($database);

$query = "SELECT = FROM news ORDER BY fecha ASC";

$result = mysql_query($query) or die ("error en query")

$num_rows = mysql_num_rows($result);

for($i=0;$i<$num_rows;$i++){

$row = mysql_fetch_array($result);

$news = "news$t";
$news = $row ("noticia");

$date = "date$i";
$date = $row("fecha");

print("&news$i=$news");
print("&date$i=$date");

}

mysql_close($connessione);

?>