Qualcosa del genere?
Codice PHP:
$query = mysql_query("SELECT * FROM file WHERE id_album ='$id'");
$lista = mysql_num_rows($query);
if($lista>2){
$rs = mysql_fetch_row($query);
$testo=$rs[3];
for ($x = 1; $x < $lista; $x++){
$rs = mysql_fetch_row($query);
$link = $rs[3];
echo "<a href=\"$link\">$testo</a>";
$testo=$link;
}
echo $testo;
}