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!
