Quote Originally Posted by DivaVocals View Post
What version of Zen Cart are you running?? The code in my files looks slightly different than what you posted.. In particular that second code block. This is what my original file looks like:

PHP Code:
// Notifier Point
$zco_notifier->notify('NOTIFY_SEARCH_FROM_STRING');

$where_str " WHERE (p.products_status = 1
               AND p.products_id = pd.products_id
               AND pd.language_id = :languagesID
               AND p.products_id = p2c.products_id
               AND p2c.categories_id = c.categories_id "

BUT...

This is what you posted as part of your original file:
PHP Code:
// Notifier Point
$zco_notifier->notify('NOTIFY_SEARCH_FROM_STRING');

$where_str " WHERE (p.products_quantity > 0
               AND p.products_status = 1
               AND p.products_id = pd.products_id
               AND pd.language_id = :languagesID
               AND p.products_id = p2c.products_id
               AND p2c.categories_id = c.categories_id "

I am running 1.39h. My apologies - I modified that block of code prior to tackling the hideCategories search issue (if I look the files for one issue for too long, I get cross-eyed so I jump around from issue to issue). If anyone is interested, the modified code that I used is for hiding sold out items from the search (a lot of my stock are one-of-a-kinds so there isn't any use for them to be in the search after they're sold).

The unmodified code would be as you stated.
PHP Code:
// Notifier Point
$zco_notifier->notify('NOTIFY_SEARCH_FROM_STRING');

$where_str " WHERE (p.products_status = 1
               AND p.products_id = pd.products_id
               AND pd.language_id = :languagesID
               AND p.products_id = p2c.products_id
               AND p2c.categories_id = c.categories_id "