SQL syntax error

I keep getting this error when I click on any of the product categories on the "Products" drop down menu...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANDProductID IN (SELECT ProductID FROM ps3_productcategories AND(CategoryID = 3)' at line 1

and when I'm on a page the accordion menu on the side with the product categories doesn't work...it's probably related to the above error as well.

The url is www.1to1marketing-llc.com

thanks

This may be caused by the ANDProductID not having a space between them. Did you make any modifications to the query that gets the categories?

Not that I know of, can I upload some files so you can take a look?

Yes, if you upload your Products_Results.php page, I can take a look at it and see if there's an incorrectly coded query.

here it is...

Try using the version I attached. This will ensure that there is a space between the AND and ProductID.

posted it and now I get this error

WHERE ProductID IN (SELECT ProductID FROM ps3_productcategories WHERE (CategoryID = 4))

Just wanted to make sure that the query was being written out correctly. Go to line 85 of that page and delete this code:
die($WADbSearch1->whereClause);

Then run through again to see if you get an error.

got the initial error again...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANDProductID IN (SELECT ProductID FROM ps3_productcategories AND(CategoryID = 6)' at line 1

On line 84, that should look like this:
$WADbSearch1->whereClause .= "ProductID IN (SELECT ProductID FROM ps3_productcategories WHERE (CategoryID = ".implode($_GET["ProductCategoryID"]," OR CategoryID = ")."))";

Change it to look like this:
$WADbSearch1->whereClause .= " ProductID IN (SELECT ProductID FROM ps3_productcategories WHERE (CategoryID = ".implode($_GET["ProductCategoryID"]," OR CategoryID = ").")) ";