Search dropdown to search boxes?

[ladysniper]

I need to take a dropdown search box and change it to stand alone search boxes that will pull from my MySQL db.

This is the code I have for the dropdown box:


[code]
<form method="post" action="http://azsoma.info/results.php" target="_blank">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td bordercolor="#000000">
<p align="center">
<select name="metode" size="1">

<option value="Name">Name</option>
<option value="City">City</option>
<option value="Zip">Zip</option>
</select> <input type="text" name="search" size="25">  <br>
Search for members: <input type="submit" value="Go!!" name="Search"></p>
</td>
</tr>
</table>
</div>
[/code]
Can someone tell me how to take that same code and make standalone search boxes?

Like this:

Name(input box)
City (input box)
Zip(input box)

If I just try the regular html code I have? It searches everything and ALL the members in the db shows up.

Thanks!