I have a database which is about shops in different cities and products they offer.
I have one column which is the "city" and then 6 different columns with products (product 1...product 6). If a shop offers the specific product the value of the field under the product is "yes".
What I want is to have 2 dropdowns, one for city, and one for products, so users will select the product they want, then the city they want, and the list will show the shops in the specific city that offer the specific product.
Any ideas how to do it?