This is my first post. I am a novice at php.
I have four fields in my db. The fields are Source, Topic, Subtopic, Theswords, References, and Lnum. All fields are text except for Lnum.
I need to know how to change the Select statement below so that when a search is done, the result will be what the user selected in the drop down box on the form. The old Select statement below works fine. Previously, I was not using Full Text and I did not currently have a drop down box with text related criteria.
This is the old Select Statement on the php page called by the html form. This Select statement does not have any of the drop down box variables in the statement.
$query = "SELECT * FROM `View2_Concord` WHERE `Topic` LIKE '$SeeAlso%'
AND `Source` IN ('NV', 'TR', 'BT')
ORDER BY `Lnum` ASC";
Currently, the user selects the source field values of NV, TR, and/or BT by checking checkboxes on the html form below. I have added a new drop down box with text search related values.
Question: How do I change the Select Statement above to accomodate the drop down box values?
Question: Do I need to run the db search in Full Text to be able to use the search terms in All Words, Any Words, Exact Phrase, and Boolean formats?
This is the form on the html page.
<div align="center">
<center>
<table border="2" cellpadding="2" width="685">
<tr>
<td width="671">
<form method="Get" action="PostNewABC_Concord.php">
<p><b><font face="Arial" size="2"> Tens <input type="checkbox" name="TR" value="ON">
Bats <input type="checkbox" name="BT" value="ON"> Neds <input type="checkbox" name="NV" value="ON">
<br>
</font></b><select size="1" name="SearchSelect">
<option selected value="AllWords">All Words</option>
<option value="AnyWords">Any Words</option>
<option value="ExactPhrase">Exact Phrase</option>
<option value="Boolean">Boolean</option>
</select></p>
<p><input type="text" input name="SeeAlso" size="20"><input type="submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
<p> </p>
</table>
</div>
</center>
Thank you in advance for any replies.