Hello,

I've done a lot of reading on different search options, and I think what I need to be done can be done, but I wasn't sure what information I found applied to my situation.

Here's what I need to do:

On a static web page, set up a search based on 3 drop-down menus, like this:

<form action="cgi-bin/dbman/db.cgi" method="GET">
<input type=hidden name="db" value="default">
<input type=hidden name="uid" value="default">

<select name="*"><OPTION VALUE="*">Search for a
<OPTION value="DIL">Drive In Lodge
<OPTION value="FIL">Fly In Lodge
<OPTION VALUE="BB">Bed and Breakfast
</select>
<br><select name="*">
<option VALUE="*">That offers...
<OPTION value="CO">Canoe Outfitting
<OPTION value="ECO">Eco Tours
<OPTION value="WA">Winter Accommodations</select>

<br><select name="*"><option VALUE="*">And provides...
<option value="AP">All meals
<option value="HK">No meals</select>

<INPUT TYPE="HIDDEN" NAME="mh" VALUE="10" SIZE=3>
<INPUT TYPE=HIDDEN NAME="sb" VALUE="ID">
<input type="submit" NAME="view_records" value="Go">
</form>

The problem is that each of these cryptic codes (AP, HK, CO, ECO, etc) are different categories in default.cfg, like this:

'HK' => [10, 'alpha', 0, 2, 0, '', ''],
'AP' => [11, 'alpha', 0, 2, 0, '', ''],
'MAP' => [12, 'alpha', 0, 3, 0, '', ''],
'PP' => [13, 'alpha', 0, 2, 0, '', ''],

Usually, you specify the category in <select name="category"> but since they're all different categories, I figured I'd have to do this by keyword?

If I do have to do this by keyword, would I have to implement part of the boolean MOD to allow AND searches? And what about exact matches. The code AP may match the word "apartment" for example in another field. I'd just want AP resuts returned.

I would appreciate any help anyone can give. Please!!