Ciao eseguendo questo codice in php:

<?php ---------------------------------

require ("Connessionearbitro.php");

$query = "select idS,idP from Squadra,Partita where Partita.in-casa=Squadra.nome;";

$result = mysql_query($query, $conn);

while ($line=mysql_fetch_array($result, MYSQL_NUM)) {

$query2 = "insert into Gioca (idS,idP,data) VALUES ('$line[0]','$line[1]','1/10/2009');";

$result2 = mysql_query($query2,$conn);

}

mysql_close($conn);

?> ----------------------------------------------



mi da questo tipo di errore:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource on line 9

Perchè????