Following on from our conversatrion yesterday, I have managed to get the results page working (with the add to cart functionality) and filtering... in the main.
I am now trying to get the search results to also filter out products that may be members of a category that has been hidden.
I am pretty sure I need to add to the inner join (?) I already have but my efforts arent working. I have added the results.php file and 2 screenshots of the 2 different tables in the database in th PM section.