errore query

[eliJS]

Sostituisci:

<?php 
$query="SELECT cinema_ana_film.*, cn1.id_cinema_nazioni AS cn1.id_cinema_nazioni1 
        FROM cinema_ana_film, cinema_nazioni cn1 
        WHERE cinema_ana_film.nazione_1=cn1.id_cinema_nazioni1 
$ris_query=mysql_query($query, $conn) mysql_error(); 

while($row_film=mysql_fetch_array($ris_query)){?>

con:

<?php 
$query="SELECT cinema_ana_film.*, cn1.id_cinema_nazioni AS cn1.id_cinema_nazioni1 
        FROM cinema_ana_film, cinema_nazioni cn1 
        WHERE cinema_ana_film.nazione_1=cn1.id_cinema_nazioni1";
$ris_query=mysql_query($query, $conn);
mysql_error();

while($row_film=mysql_fetch_array($ris_query));
?>