Multiple choice dropdown search form

[brett]

I am trying to make a search form that has 3 dropdown lists containing possible search criteria. Category, Property, and State. I am having a real hard time trying to figure out how I can work it so that the search will be able to use all those fields. I am tyring to search records in a MySql database.
Any ideas?
Brett

[stolzyboy]

you may want to do some if statements and such incase people don't always choose some selection, but you could just do

select * from table where category = '$cat' and property = '$prop' and state = '$state';