Skip to main content
L
LawWorks_Graham
Participant
January 5, 2011
Question

Multiple search but not all options chosen

  • January 5, 2011
  • 1 reply
  • 276 views

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.

This topic has been closed for replies.

1 reply

David_Powers
David_Powers
Inspiring
January 5, 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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices