How can I show stores with same product

Hey guys! Could you help me?

I’m creating an app to find any product in many stores and show their prices. I don’t know if I’ve done right because I had to create 3 tables. First table is store, second is product and third is price-product with columns store, product and price.

In the product page I want to show all stores with that product and show their prices. This is the problem, I don’t know how to do it…

How can I show only stores that have this product? For instance, I selected Shoes, I go to this shoes page and see this product in Store A, B, C with their prices.

Shoes

Store A: $10
Store B: $20
Store C: $30

Check out this thread…may be a good starting point for understanding how to set up the database for products

This topic was automatically closed after 70 days. New replies are no longer allowed.