product hidden in search results

[hamelin85]

hello and thanks for your support.
how can I make a product invisible to the search?
i thought i have to modify sequel database.

regards

[bunyip]

in includes/modules/pages/advanced_search_results/header_php.php,
find this code

$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 "; 

and add an extra condition

AND p.products_id <> xxx 

where xxx is the product id of that which you don't want displayed in the results.

[hamelin85]

thanks. but it doesn't work. i can see the item in the results. id number is correct.
maybe we have to specify other things?

[hamelin85]

now it works. i miss to move a ". thank you very much.

i don't know well php code. how could I add more invisible product?

i mean: AND p.products_id <> xxx and xxx and xxx

thanks for your answers!