intendevo qualcosa di questo genere....
codice://Prima query $query = "SELECT * FROM Correlate WHERE News1 = '$News' OR News2 = '$News'"; $result = mysql_query($query, $db); while ($row = mysql_fetch_array($result)) { $id1 = $row["ID"]; $n1 = $row["News1"]; $n2 = $row["News2"]; $query2 = "CREATE TEMPORARY TABLE IF NOT EXISTS temp SELECT * FROM News WHERE (ID = '$n1' OR ID = '$n2') AND ID != '$News' AND Data <= Now()" ; $result2 = mysql_query($query2, $db); } $query3 = "SELECT * FROM temp ORDER BY Data DESC"; $result3 = mysql_query($query3, $db); while ($row2 = mysql_fetch_array($result3)) { $id2 = $row2["ID"]; $tit = $row2["Titolo"]; echo "<a href=\"pag.php?Pag=news&News=$id2\" title=\"$tit\">$tit</a> "; }

Rispondi quotando