Excluding category from search

[kgeoffrey]

Hi there,

What is the best way to exclude all the products in a given category from the search results? I'm using Zencart 1.3.0.1

Thanks!

[yellow1912]

http://www.zen-cart.com/forum/showthread.php?t=75079

You can apply similar rule to your case.

[kgeoffrey]

Excellent! Thank you so much. Worked like a charm.

I changed

               AND p2c.categories_id = c.categories_id "; 

to

               AND p2c.categories_id = c.categories_id
               AND (c.categories_id < 9 OR c.categories_id > 10) "; 

to exclude categories 9 and 10. I don't know if that was the "right" way to do it, but it worked.

Thanks again!

[yellow1912]

You can also try

AND c.categories_id <> 9 AND c.categories_id <> 10

samething