product extra fields advanced search help needed

[guyrab]

Hi Newbee to OSC.

1. I have installed the extra fields contribution (version j). it all worked except the search/advanced search. got an SQL error. then I have downgraded the advanced search result.php and advanced search.php to the previous version. now it works! Did I do the right thing?

 

2. I have added five new extra fields to my product. I would like to add them to the advanced search query (AND relation). how do i do that?

 

thanks for any help

[Guest]

Try the NewFields4-march-5 contribution. I added it to my store and it works great. Take out the changes you made to your product info first, before adding this contribution. As you add the new fields, just change the word artist in the 'products_artist' to what you want for that field. I used it to add keywords to my product info as I deal with stock photography which needs to have the capability of being searched by keywords associated with the images. I didn't want to clutter up my description with the keywords. This contrib worked perfectly for me. Good luck with it!

 

Lefty

[guyrab]

Try the NewFields4-march-5 contribution. I added it to my store and it works great. Take out the changes you made to your product info first, before adding this contribution. As you add the new fields, just change the word artist in the 'products_artist' to what you want for that field. I used it to add keywords to my product info as I deal with stock photography which needs to have the capability of being searched by keywords associated with the images. I didn't want to clutter up my description with the keywords. This contrib worked perfectly for me. Good luck with it!

 

Lefty

 

 

thanks lefty. going to try it right away. looks just what I needed! :thumbsup:

[guyrab]

it works. thanks again. but it misses one feature I need.... I need to be able to advance search according to the extra fields I have added, not using the keywords search box, but having these extra fields boxes of there own to fill in values I would like to search for (with an AND relationship). do you have any ideas on an existing contribution for this?

 

thanks in advance

[guyrab]

it works. thanks again. but it misses one feature I need.... I need to be able to advance search according to the extra fields I have added, not using the keywords search box, but having these extra fields boxes of there own to fill in values I would like to search for (with an AND relationship). do you have any ideas on an existing contribution for this?

 

thanks in advance

[nicko107]

Hi Newbee to OSC.

1. I have installed the extra fields contribution (version j). it all worked except the search/advanced search. got an SQL error. then I have downgraded the advanced search result.php and advanced search.php to the previous version. now it works! Did I do the right thing?

 

2. I have added five new extra fields to my product. I would like to add them to the advanced search query (AND relation). how do i do that?

 

thanks for any help

 

 

Hello

 

comment or delete this line:

 

$from_str .= ", " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

 

see this:

 

http://www.oscommerce.com/forums/index.php?showtopic=198715

[guyrab]

I have already changed everything back and then used the other contribution, so now I am not going to revert back to extra fields I think... it was quite a job to do, and the query works now, I only want to separate the new added fields in the advanced search query so that I can search according to a value in them,

so if I have 5 new extra fields, I would like them to appear in the advanced seatch query window separately, and that I could search according to their values (AND relationship). this was not possible with the extra fields contribution BTW;

 

thanks