I've searched trying to figure out what I'm doing wrong. What I'm trying to do is this, create a search page which allows a user to enter a keyword and then select a variable with which to associate that keyword.
you can see an example <a href="http://www.techiekb.com/~drew/projects/frame_db/search2.php">here</a>
What I'm doing in the script to process the form input is creating of course a variable based on the keyword which gets set when the user enters that keyword and its passed onto the script, the second portion where the user selects from the drop down menu I have it set as an array in the script so that atleast one value is set, and then the syntax to call it is as follows:
$Query = "Select * ";
$Query .= "From customer_data where '%$search_array%' like '%$search%'";
if(!($dbResult = mysql_query($Query, $dbLink)))
search_array being the array I've built with the possible variables available from the drop down menu, what happening is that when a user enters a keyword then selects an option from the drop down menu it prints a page showing no results basically.
If I remove the select option completely and the user does it using only a keyword(s) then it works as expected, but it limits the users ability to choose which way they want to search. I hope this makes sense and I appreciate anyone's help in advance.
Drew
