Problem searching database from three seperate form entries
Posted: Mon Jun 25, 2007 3:12 pm
Hi there! I'm having trouble figuring this out. Any help would be greatly appreciated.
I have a form that has three text input boxes. I would like for them to each search a separate column in the same database when the user hits the submit button. For example, the first field in the form is "author" so the user would put in an author's name like "Spurgeon." The user could also put a topic into the "topic" search box like "faith." When the user submits the submit button I would like to to display matching records from only the "author" and "topic" columns in the database. In the case of this example only records containing "spurgeon" from "authors" and "faith" from "topics" would be displayed.
Anybody have an idea on the best way to go about this?
I have a form that has three text input boxes. I would like for them to each search a separate column in the same database when the user hits the submit button. For example, the first field in the form is "author" so the user would put in an author's name like "Spurgeon." The user could also put a topic into the "topic" search box like "faith." When the user submits the submit button I would like to to display matching records from only the "author" and "topic" columns in the database. In the case of this example only records containing "spurgeon" from "authors" and "faith" from "topics" would be displayed.
Anybody have an idea on the best way to go about this?