Hello,

Trying to figure out the best or rght way to do this. (PHP/MySQL). I have
table that contains a lot of columns in which the value is either 'Yes' or
'No'. I want to create an advanced search page where the user can select
"Yes', 'No', or totally choose to ignore the list menu as a compnent of their
search criteria. The form would have 4 to 5 list/menus. So for one search
the user may select 3 columns from three list/menus, in another search the user
may select 2 columns using just two of the list/menus. I would like to do
this with one form submit.

So.. the issue surrounds the column(s) that the user chooses to ignore. In
other words, the user does not care if the value in the column is "Yes" or
"No". If a user selected from just two of the list menus, the query would need
to compare table colums with the values the user selected from the List/Menu,
such as WHERE column1 = formfield1 AND colum2 = formfield2. But... what
do I do about the other columns that were not selected. For unselected list
menus I really need the query to return rows that have values of "Yes' OR 'No"
in the columns the user didn't care about.

What I was thinking is that each select box should have a default value of
anything, such as, "not selected". Then when the query runs, the values for
any list box that has a value of "not selected" needs to utilize an 'OR' to
returnrows with 'YES' OR 'No' in those columns.

I have no idea if this can be done using a list box. Just tossing it our here
to see if anyone can point me in the right direction.

Thanks