Assistance with feature enhancement - checkboxes

[arthurema]

I currently have an interface through the admin console to access and insert data into a new table. I am basically using two columns, a key and values. What I want help with is that when I go to the advanced search page, a key is queried and checkboxes are created using all the values in that column. All values is a comma delimited list. The table looks similar to;

 

| id | key | values |

| X | * | sticker, women, men, peace, tatoo, etc........ |

|X+1 | ** | red, orange, butterfly, dragon,etc.................|

next....etc.....

 

The values come from my loging of successful search queries performed. I have a logging table for sarched terms and through the admin console, I can generate stats on successful search terms manually to determine the top 10, or a row of values.

 

This will provide the user a keyword search on all titles and descriptions with a known or forced set of keywords as defined by the admin.

 

My problem is that I have a large catalog (over 2000 items) of three types of products like pens, pencils, and markers. With each of these three has many unique features which are used in the description of the products.

 

Could anyone help me to write this checkbox feature? All I need is to add the query of the adv serach page to the correct table, build the checkboxes, and if the checkbox is selected, use it's value as part of the keyword search.

 

Thanks..............