Help with Search Form

Hi dlsweb, 

The underscore in the fieldname shouldn't cause a problem.  Here's a couple tips and things to look out for, though: 

For your state pulldown, you may want to provide an option to list all states: 

<select name="state1">
<option value="">&lt;any&gt;</option>
<option value="AL">Alabama</option>
<option value="AK">Alaska</option>
<option value="AZ">Arizona</option>
</select>

And for your check boxes, each option will overwrite the previous.  If you want to show records that match ANY of the checked boxes (performs an OR search query) you need to add square brackets to tell PHP to submit the values as an array instead of overwriting each other: 

<input type=checkbox name="type_vendor[]" value="FandB"> Food and Beverage<br>
<input type=checkbox name="type_vendor[]" value="Product"> Arts, Crafts, Product<br>
<input type=checkbox name="type_vendor[]" value="Service"> Service Provider<br>
<input type=checkbox name="type_vendor[]" value="Attraction"> Attraction<br>

And for debugging you can see the actual MySQL being generated and executed by temporarily adding this option: 

    'debugSql' => true,

Hope that helps!