mysql syntax help

adnan1983

        $get_data = "SELECT fileName, writerName FROM writer WHERE reviewerName='$checkNull', reviewerName2='$checkNull', reviewerName3='$checkNull' AND dcName='$valid_user'";
        $search = mysql_query ($get_data);
        $total_files = mysql_num_rows ($search);

I keep getting this error, can anyone see any syntax error in the statement.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site70/fst/var/www/html/asee/dcNews.php on line 44

LordShryku

Your SQL is wrong. You need to use AND instead of commas.

SELECT fileName, 
       writerName 
FROM writer 
WHERE reviewerName='".$checkNull."'
AND reviewerName2='".$checkNull."' 
AND reviewerName3='".$checkNull."' 
AND dcName='".$valid_user."'

adnan1983

thanks it worked.

superwormy

ALWAYS use mysql_query ($your_query) or die (mysql_error()); so that you can see your SQL errors.

ALWAYS.

Either that or write a function to handle errors like this for you and log them somewhere.