I am coding a search form in php and would like to have some help on how to build it, following is the HTML code for the form
<table width="93%" border="1" align="center">
<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post" />
<tr class="style1">
<td width="12%">Country</td>
<td colspan="3"><input name="name" type="text" id="name"> </td>
</tr>
<tr class="style1">
<td>Category:</td>
<td width="40%"><select name="category">
<option value="Business Development">Business Development</option>
<option value="Information Technology">Information Technology</option>
<option value="Leadership and Management ">Leadership and Management </option>
<option value="Engineering ">Engineering </option>
<option value="Monitoring & Evaluation">Monitoring Evaluation</option>
<option value="Accounting Finance" selected>Accounting Finance</option>
<option value="Business Development">Business Development</option>
<option value="Corporate Affairs">Corporate Affairs</option>
<option value="Finance & Accounting">Finance & Accounting</option>
<option value="Human Resource Management ">Human Resource Management </option>
<option value="Organizational Development ">Organizational Development </option>
<option value="Quality Assurance ">Quality Assurance </option>
<option value="Resource Mobilization">Resource Mobilization</option>
<option value="Social Mobilization ">Social Mobilization </option>
</select></td>
<td width="19%">Fee:</td>
<td width="29%"><select name="fee" id="fee">
<option value="Less then US$ 20 " selected>Less then US$ 20 </option>
<option value="US$ 20 - 50">US$ 20 - 50</option>
<option value="US$ 51 - 80 ">US$ 51 - 80 </option>
<option value="US$ 81 - 100 ">US$ 81 - 100 </option>
<option value="US$ 101 - 150 ">US$ 101 - 150 </option>
<option value="Above US$ 150">Above US$ 150</option>
</select></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td><div align="right">
<input name="submit" type="submit" id="submit" value="Search">
</div></td>
</tr>
</form>
</table>
Now i need to query in such a way that if user selects one option the records should match that option ..if the user selects 2 out of the 3 search options ..the results should be based on onlyy those 2 options..plz guide me
