Search functions help..

[molywerks]

Allister,

I only edited two files to get my search to go into my products table and scan the extra fields I added and return results. The instructions below may be too exacting, but they work. And I won't be bothering with cleaning up unnecessary codes for several weeks.

Anyway, here is what I did:

PART ONE
1. OPEN includes\index_filters\default_filter.php
2. SEARCH for $listing_sql = "select " . $select_column_list . "
3. INSERT your new table fields [Note: I am not sure this is necessary or not either, but I inserted my fields in the same exact order as they appear in my products table. Since all my fields were tacked on at the end, I placed my fields AFTER `p.products_tax_class_id, ` and BEFORE `pd.products_description, if` (ignoring the `backticks` of course).]
4. Repeat steps 2 and 3 three more times.

PART TWO
1. OPEN includes\modules\pages\advanced_search_result\header_php.php
2. SEARCH twice for LIKE '%:keywords%'.
3. INSERT AFTER OR details_model_name\nLIKE '%:keywords%' and BEFORE OR m.manufacturers_name\nLIKE '%:keywords%'"; your information in the same `OR p.yourfield`\n`LIKE '%:keywords%'`.

Hope this helps!

[dropbop]

Allister,

I only edited two files to get my search to go into my products table and scan the extra fields I added and return results. The instructions below may be too exacting, but they work. And I won't be bothering with cleaning up unnecessary codes for several weeks.

Anyway, here is what I did:

PART ONE
1. OPEN includes\index_filters\default_filter.php
2. SEARCH for $listing_sql = "select " . $select_column_list . "
3. INSERT your new table fields [Note: I am not sure this is necessary or not either, but I inserted my fields in the same exact order as they appear in my products table. Since all my fields were tacked on at the end, I placed my fields AFTER `p.products_tax_class_id, ` and BEFORE `pd.products_description, if` (ignoring the `backticks` of course).]
4. Repeat steps 2 and 3 three more times.

PART TWO
1. OPEN includes\modules\pages\advanced_search_result\header_php.php
2. SEARCH twice for LIKE '%:keywords%'.
3. INSERT AFTER OR details_model_name\nLIKE '%:keywords%' and BEFORE OR m.manufacturers_name\nLIKE '%:keywords%'"; your information in the same `OR p.yourfield`\n`LIKE '%:keywords%'`.

Hope this helps!

I know its an old tread, but I have been searching everywhere for a way to make my new fields searchable.

Its spot on, works like a charm and very easy to do. I have just made all my new fields searchable.

I have also seen many other people looking for the same fix, so I hope bumping this post will help other to find it quicker