Add new fields into advanced search keywords

[rubygirl]

okay - i have successfully added multiple fields to my store - they all display correctly in product_info.php page and they all are added/updated successfully via the admin - my problem now is that i need the keyword search to search the new tables as well - all tables are in the product table - which file do i need to edit in order to include the new tables???

 

please help! i am so close :'(

[OceanRanch]

The file is

 

catalog/advanced_search_result.php

 

around line 369 or so you'll need to add your newly defined column names

 

$where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'";

 

$where_str .= " or pd.new_field_name like '%" . tep_db_input($keyword) . "%'";

 

HTH

Tom