Search with multiple drop down boxes

[aneesh29]

Hi
I have a search pege in my website.I am developing in PHP/MYSQL.
search page contains three drop down boxes
1:Country
2:Education
3:age

Country contains:All,US,Canada etc
Education Contains:All,Highschool etc
Age Contains:All,20,21,etc

How can i write sql statement to satisfy this criteria to get values from database.

Thank you so much for your help

[ssystems]

Use AND in your Where clause

[nap0leon]

If "All" is chosen for any drop-down, exclude that from the WHERE clause. Since any (or all) of the items may be "All" you will need to make sure that your first "where" condition uses "WHERE" and not "AND" (e.g., if the user chose "All" for Country, then the statement would be "WHERE education=..." not "AND education=...")

Select * from TABLE
WHERE country = <selected country>
AND education = <selected education>
AND age = <selected age>

[scaleautostyle]

Hi aneesh29!

I think I can help you with this one because I done one like this. just checj here if it's the way you want. in my case you can choose one OR more critery t do your search.. here's the link

http://scale24-25.com/search-db-foreach.php

rigth now I try to expend this search to an other level.. but got some problem... I will post it on an other thread.

so let me know if it's what you want. if yes drop me a mail I will send you the code for them

hope it will help

S

[aneesh29]

hi thanks for your reply
i am looking exact search form like you.
can you please send me the code.
Thank you so much

[scaleautostyle]

hi!! check this thread..

http://www.webdeveloper.com/forum/sh...51#post1202651


you can took the 2 first batch of code it's my files

yours

S

[shalli]

Hi scaleautostyle

The code you have produced is exactly what I am looking for

Can you please send me your code please. I would like to narrow a user result depending on the criteria they choose via the drop down menu.

I really appreciate your help with this

many thanks

shalli

[scaleautostyle]

hi!! jsut go in the thread I post before. copy clip the code into your file and VOILA.

yours

S

[shalli]

Hi scaleautostyle

I got confused because you said you got a error

did you modify all the php code

just confused can you zip and send me the files please

if not then no problem

thanks for your response

shalli

[scaleautostyle]

the first 2 files are in working condition like they are in the site rigth now. the non working one are after.

yours


S


PS: I don't send any file by mail due to some problem in the past on other forum.