handling numerous select names

[Anon]

I have an html form that has three pulldown menus to select from before the user hits submit to search the database. How would I write the SQL in my php script to search the database on these three different select names?

[Anon]

I would help you out but I need a bit more detail, what exactly do the three pulldown menus relate to? For eg. is one of them an attribute in the database and the other two conditions of the search?

Give as much detail as you can and it'll make getting help much easier 😉

[Anon]

The database contains information about vacations that we provide. The colums are trip name, region, country, description, price, grade, lodging. On my html page, I let the user select from region, country, and cost. Here is where I get stuck. Once they have there three options selected, they hit the submit button. I have it calling a php script... I want that script to be able to perform a query on the database depending on the three selected options.

[Anon]

Ok, so it might be something like this..
- the select part can be whatever data u need the user to see or need to mani..
- i don't know what your table is called so i used vacationtable )

SELECT tripname, description, price
FROM vactiontable
WHERE region = "$region"
AND country = "$country"
AND cost < "$cost";

i am assuming you know how to perform the SQL query etc..

of course this might not be exactly what you need but it would be something similar, hope it helps you a bit.

[Anon]

Thanks... Another question if you don't mind 🙂

What if the user wants to look at all the countries in a region or all the regions? This script only works if they have something selected.