i have a table with following columns:
name, city, state, country.
i want to be able to filter data based on the user's selections. that is name of the person, city, state, country. (city, state, country are menus/lists containing "ALL" option as the first option meaning they some may be selected as "ALL"). also 'name' is a text field and it may be empty. How can I perform this filter. I desperatly need help!.