Multiple search but not all options chosen

Report · Jan 05, 2011

I am using CS4 to produce a database using mySQL and php.

I have a table which records a number of variables, each variable being listed in a separate tabel and selected from dropdowns. (For example, London Boroughs, age bands, type of work - the field names are boro, age, work respectively)

I have built a search page which allows a user to select from each of the 3 drop downs and get a list of data which meets the combination selected. BUT if I don't make a choice from one of the lists then I don't get any results.

How can I make it so that I don't have to make a selection from all of the dropdowns?

Thanks for any help.

Report · Jan 05, 2011

Thread moved to the Dreamweaver Application Development forum, which deals with server-side issues.

LawWorks Graham wrote:
I have built a search page which allows a user to select from each of the 3 drop downs and get a list of data which meets the combination selected. BUT if I don't make a choice from one of the lists then I don't get any results.
How can I make it so that I don't have to make a selection from all of the dropdowns?

Dreamweaver won't do this out of the box for you. You need to hand code it yourself. See http://cookbooks.adobe.com/post_Create_search_query_with_optional_fields-16245.html.