finding blank fields query issue

viveleroi0

I sometimes have MySQL fields that end up with spaces in them... which I want to use a query to find all fields=" "... but when I coded this:

$Empty_Query_Cat=mysql_query("SELECT * FROM $Prod_DB WHERE (ProdCat=\" \") OR (SubCat=\" \") OR (SubCat3=\" \") OR (ProdMisc=\" \") OR (ProdImage=\" \")OR (ProdDesc=\" \") OR (ProdName=\" \") OR (ProdPrice=\" \") OR (ProdDate=\" \")");
$num=mysql_num_rows($Empty_Query_Cat);

It gives an SQL error. I tried it without the parenthesis (sp), and it did not help.

Any ideas?

dotbob

what's the error?

Use the mysql_error() function to find out.

viveleroi0

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/www/jazbot/php/SCPM_2_0_a/PM/module_diagnostics.php on line 86

Line 86 is the query you see above...

dotbob

can you also echo out the SQL

i.e.

echo "SELECT * FROM $Prod_DB WHERE (ProdCat=\" \") OR (SubCat=\" \") OR (SubCat3=\" \") OR (ProdMisc=\" \") OR (ProdImage=\" \")OR (ProdDesc=\" \") OR (ProdName=\" \") OR (ProdPrice=\" \") OR (ProdDate=\" \")";

and post it here?

Cheers