I posted this in the MySQL forum and after 3 days without any help I thought I might have it posted in the wrong forum so I am posting it here.
I am trying to query a terms database with multiple text boxes. The user has a choice of how many text boxes they want (i have this part done), they would put one term into each text box. The would have the option of checking a check box for pronunciation, date of origin, etc. These check boxes when checked would search all terms in the text boxes and return the data if available along with the definitions of each term. The definitions for each term will be listed as 1, 2, 3, etc. the output should look like this:
1. A building for human habitation.
2. A shelter for an animal
3. A building where something is stored.
However, each of the numbered definitions should have a check box to the left and when checked and submitted will show another page with the results of the checked boxes as well as the term.
I am having difficulty getting past the select the number of word boxes. I don't seem to be able to get the query to work for the search.
Can anyone help with the type of query or script help that I would need to make.