I need a script to do advanced searching of text fields in a MySql database.
The database has three fields to be searched. The fields are Topic, Subtopic, and Thesaurus.
The form has:
One input box where users type in their search request
A drop down box showing the fields and/or the combination of fields to be searched
A drop down box with selections for "All Words", "Any Words", "Exact Phrase", and "Boolean"
The form also has a "Go" button to start the search process.
I have a display script but a simple display script showing the contents of every found record would get me started on integrating what I currently have with any new script addition.
Thank you in advance for any replies.