I'm selecting entries from my database based on the user's entry in to a form field named 'businesstype'. My query goes somehing like this:
Code: Select all
$query = ("SELECT * FROM business_directory WHERE Type LIKE '%$businesstype%'");For example, if the user enters 'car', the results should include 'car dealers', but not 'caravan sites'.