OSCOMMERCE SUPPORT CALL 702-453-3332

I'm trying to amend the search to include a couple of new fields from the product_description table, but can't work out how to do this. Any chance somebody could lend a hand?

Thanks

Ian

I am interested in it too

also removing existing fields or modifying

Your search string is composed in advanced_search_result.php, you could change the line

$where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'";

to something more suitable. As long as it is text searches you are after you can basically replace the fields that are there with the ones you want to look in or add on to the list.

Thanks. Where would I change the query to make the new fields available?

Okay, found it. For anybody else wanting to do this you change the search string as described by Mav666 above, then you look for the following string and make the same change there.



So if you are running the header tags contribution and want to include the keywords in the search, the field you need to add is pd.products_head_keywords_tag.

Ian