Skip navigation links

MySQL Forums :: PHP :: Retrieving Data from 3 tables


Advanced Search

Retrieving Data from 3 tables
Posted by: Darshan Makadia ()
Date: June 19, 2013 06:44PM

Hi,

I want to retrieve data from 3 different tables.

The Table structure is as below:

PRODUCTS
--------
ID
NAME

CATEGORY
--------
CATEGORY_ID
NAME

CATEGORY_PRODUCTS
-----------------
CATEGORY_ID
PRODUCTS_ID

DESIGNER
--------
DESIGNER_ID
NAME

DESIGNER_PRODUCTS
-----------------
DESIGNER_ID
PRODUCTS_ID

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.

Thanks

Options: ReplyQuote


Subject Written By Posted
Retrieving Data from 3 tables Darshan Makadia 06/19/2013 06:44PM


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.