I am after some help...
I have a simple PHP search engine I have construct with 2 field, one a textarea called "search" and another a drop down menu called "type".
I want to search a MYSQL database for the "search" entered by the user but it must only search for that "type", for example.
Search = Bosch
Type = Drills
I want it to only search fields in "drills" for the keyword/s "Bosch". I have constructed the form/s and results page however, all works fine when I search for Bosch in drills however when I search for example Makita in drills in still shows the Bosch results...
Could anyone provide the SELECT part that I need to use?