Almost. I found not to get an error, I had to adjust your suggestion for line 144 to $query_WADAproducts = sprintf("SELECT category.Category, ID, Small_pic_Name, Product_Name, Product_Name, Description, Color FROM products INNER JOIN category ON category.Category_ID = products.Category_ID ORDER BY Product_Name ASC" - I think you were mississing the 'sprinf'
I added the line 23
Not sure I understood how much of the Where clause to remove? I removed from line 11 - $WADbSearch1_DefaultWhere = "";
File is attacheed with the above changes
So now I am getting all products/all categories for all products_results.php??? pages - not filtering by category in the dropdown.
What am I missing? Please advise or perhaps correct the attached file.