MySQL Query Help plz!

[intermediate]

I get this error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/chris/public_html/digi/survey/results.php on line 19

when i use this mysql query statement:

$requete = "select * from $table1 where (color='$color' AND word='$word1') OR (color='$color' AND word='$word2') OR (color='$color' AND word='$word3') OR (color='$color' AND word='$word4') OR (color='$color' AND word='$word5') OR (color='$color' AND word='$word6') OR (color='$color' AND word='$word7') OR (color='$color' AND word='$word8')";

The mysql connection and other parts of the query are correct, because my other query statements work. Could someone tell me how to change the above query statement so that it will work? im trying to get people to take an online survey and they are entering words they remember from viewing a set a words and im taking all the words from the database where any words they entered match the words in database under the color they are viewing.

plz help!

[viper21634]

ok, here is your problem, you are doing this

$var = "SELECT * FROM table WHERE (color = '$color' AND color1 = '$color1')";
//so on and so forth

what you need to do is this.

$var = "SELECT * FROM table WHERE (color = '".$color."' AND color1 = '".$color1."')";
//so on and so forth

[Lars_Berg]

You can simplify the query

$requete = "select * from $table1 where color='$color' AND 
word in ('$word1','$word2','$word3','$word4',
'$word5','$word6','$word7','$word8')"; 

To see what the problem with the query is, add some error handling

$result = mysql_query($requete) or die(mysql_error());