MySQL Forums :: PHP :: Retrieving Data from 3 tables
Retrieving Data from 3 tables
Date: June 19, 2013 06:44PM
I want to retrieve data from 3 different tables.
The Table structure is as below:
I want to retrieve products that belong to a certain designer and also belong to a certain category. Basically, I have a filter on the website where the customer selects a designer first which displays all the products for that designer. Category filter allows the customer to futher filter the products by selecting a particular category and filter the products based on designer and category selected.
Hope I have explained properly.
Please help me to build this query.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.