Page 1 of 1

Help implementing small search for my application

Posted: Wed Oct 05, 2011 7:27 am
by houssam_ballout
Hello,
I had a small php , mysql application & I need to include the search to it.

example of search below:

By driver:

Driver 1
Driver 2
Driver 3

By Time:
Morning
Evening
Noon

By Level:
Level 1
Level 2...

each one is a checkbox so any help on how to implement this search?
Thanks in advance

Re: Help implementing small search for my application

Posted: Wed Oct 05, 2011 9:45 am
by social_experiment
Will each of the options by included in a single search? If so, the search query could look similar to the example below

Code: Select all

SELECT * FROM table WHERE driver = 'chosenDriverOption' AND time = 'chosenTimeOption AND level = 'chosenLevelOption'