Hiya. Im doing a thing where people can search other members by age, locatation and stuff. I want it so that they can just leave out some details if they want, so in the drop down menus of the search page, i have one option that is "Dont care" and the value is set to "*". On teh search results page, i have a query like this...
SELECT * FROM user_info WHERE age >= '$search_min_age' AND age <= '$search_max_age' AND sexuality LIKE '$search_sexuality'
And its not working... i assumed that if the query had like:
"...sexuality LIKE *" in it, it would return all the results of that condition, but it seems im wrong. how do i get around this?
Thanks!
