filter based on selection, which may be "all" (was "help with SQL")
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!.
can you guys write the SQL code for me please
i can't grasp this. i guess i'm stupid. can someone please write the actual SQL statement that i would use??
great, that helped-i finally understand it. works great