Search on Specific Field

[Guest]

Hi I am doing a site for a customer, its an online book store. I have added a custom column field in the products table called "author". They don't want the search to search anything other than the author's name. can anyone please help me?

 

Thanks

[burt]

Use the manufacturers functionality as Author ? Then amend the advanced_search.php to only search on manufacturers and nothing else. You then change the language define from "manufacturer" to "author". That might be a nice solution?

 

or, as you have already added "author" as an inpiut field, you now need to amend the SQL's in advanced_search.php to only search on the author column.

[Guest]

Use the manufacturers functionality as Author ? Then amend the advanced_search.php to only search on manufacturers and nothing else. You then change the language define from "manufacturer" to "author". That might be a nice solution?

 

or, as you have already added "author" as an inpiut field, you now need to amend the SQL's in advanced_search.php to only search on the author column.

 

Thanks Burt

 

I can't see where in the advanced seach to change can you clarify, please?

[burt]

Sorry, I meant advanced_search_result.php

you'd still need to amend all those inputs and js warnings in advanced_search as well though.