Advanced search also in categories (categories_name field)

[moonflower]

Hello,

 

Does anyone know how I can extend the advanced search? I also want to search in the category names (this is the field categories_name in the table "categories_description"). Now, my search only searches in the products.

 

The goal is to get a list with the combined results (the results from the product search + the results from the category search). It should be nice if the results appear in 1 table (in the advanced_search_result.php file). Any idea how to do this??

 

I already had a look at the code in the advanced_search_result file. Probably the $select_str, $from_str and $where_str code needs to be modified, but my PHP/MySQL knowledge is not that wonderful :-"

 

Thanks for your help anyway!

 

MF

[Guest]

To extend the search changes are needed in the catalog\advanced_search_result.php You could extend the sql query for additional fields/tables scanning the dbase. Also check the contributions if enhancements already exist for categories