PHP/MYSQL CODE
Posted: Mon Sep 08, 2003 4:59 am
Hello all,
Just creatign a search system on a site and i have stumbled over a small blip. Im sure one of you know the answer to this question.
Now $jobtype can sometimes be a search by ALL so how can i wildcard it instead of editing the whole SQL. eg i know you could search for hello in a cell by using %hello% but how can i make it for anything.
All help appreciated.
Matt
Just creatign a search system on a site and i have stumbled over a small blip. Im sure one of you know the answer to this question.
Code: Select all
SELECT * FROM vacancies WHERE title = '$jobtype' AND region = '$region'"All help appreciated.
Matt