keyword select boxes - advanced_search.php

[arthurema]

Could I get a little assistance with the advanced_search.php page. I would like to add a feature that when the adv search page is loaded, it will build select boxes of defined keywords. I have a unique table with a unique ID and a field of keywords as space seperated. I would like to see the code required that will query this table and return checkboxes in two or three colums, then submit these as search terms if selected. This would be my query

select unique_keywords from 'keywords' where UID='1' or UID='2' or UID='3'

 

This unique table is already set to be managed through the admin interface.

 

One other feature would be changing the way the Quick search default returns. Currently, If i have no search terms in the Quick Search and press the Go button, the return is all products. I would prefer to load the adv search page with the abouve feature of keyword checkboxes in place of an all product list.

 

The keyword checkboxes is my priority request.

 

Thanks so much