search form question

habs20

I have a search form script that works well. It has 1 input text box and 4 drop down selection options.The options works with keywords to search my database. Script below. Instead of having the select wich fields to search from the drop down. I want to have 1 text input for each option with only 1 submit button. Any ideas or suggestions appreciated.

Current script:

<table border="1" width="100%" cellspacing="0" cellpadding="0">
<tr>

    <tr>

   <td align="right"><b>Enter Account Criteria  </b><input type="Text" name="keyword" size="20"></td>
    </tr>

    <tr>

   <td align="right"><b>Search  </b><select name="where">
    <option value="1">Account Number</option>
    <option value="2">Account Name</option>
    <option value="3">Account Rep</option>
    <option value="4"selected>All</option>
    </select></td>
    </tr>

    <tr>
    <td colspan="2" align="right"><input type="Submit" name="submit" value="Search"></td>
    </tr>

    </form>

</td>

habs20

To clarify what I am looking to do:
<tr>
<td align="right"><b>Enter Account Criteria </b><input type="Text" name="keyword" size="20"><select name="where"> <option value="1"></td></select>
</tr>

Instead of having a drop down. I want to have multiple text boxes to enter search criteria.

Thanks

theeper

If I understand you, you currently pass two variables to the script that does the search, $where and $keyword. I assume you build a query off of these values that looks something like this.

SELECT * FROM mytable WHERE $where = '$keyword'

Or something like that.

If that is the case, you just need to replace the $where SELECT form field with a TEXT form field. This way, the user has to type in a value for the $where variable instead of choosing it from the SELECT field.