Sto provando cosi ma mi restituisce errore:
codice:
$query = "SELECT DISTINCT $db_table1.id,$db_table1.nome,$db_table1.cognome,$db_table1.nato, $db_table2.id,$db_table2.nome,$db_table2.cognome,$db_table2.nato FROM $db_table1, $db_table2 ORDER BY id ASC";


echo "<table width=\"750\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" bordercolor=\"#CCCCCC\"><tr><td bordercolor=\"#FFFFFF\">Nome</td><td bordercolor=\"#FFFFFF\">Cognome</td><td bordercolor=\"#FFFFFF\">Nato</td></tr>";

$result = mysql_query($query, $db);
while ($row = mysql_fetch_array($result))
{

echo "<tr><td bordercolor=\"#FFFFFF\">".$row[nome]."</td><td bordercolor=\"#FFFFFF\">".$row[cognome]."</td><td bordercolor=\"#FFFFFF\">".$row[nato]."</td></tr>";

}

echo "</table>";

L'errore che mi da è: Supplied argument is not a valid MySQL result resource in /mio/path/

Dove sbaglio?