for instance, if they wanted to search for all the people in my_search_table who had the first name 'Glen' AND the last name 'Lambert' AND who have a birthdate of 02/05/82. how can this be done in the query? something like
Code: Select all
$result = mysql_query("SELECT first_name, last_name, birth_date
FROM my_search_table
WHERE first_name LIKE '%". fname ."%' AND last_name LIKE '%". $lname ."%' AND
birth_month LIKE '%". $birth_month ."%' AND
birth_day LIKE '%". $birth_day ."%' AND
birth_year LIKE '%". $birth_year ."%'")
or die(mysql_error());