[RESOLVED] multiple table query select problem

cbesh2

I know this problem has been addressed in other posts but I'm unable to apply it to my situation.

I have mutliple tables:

PRODUCTS
     prodID
     description
     typeID
     themeID
     colorID
     sizeID

TYPE
     typeID
     type

THEME
     themeID
     theme

COLOR
     colorID
     color

SIZE
     sizeID
     size

I want to display everything that is in the database with the related values. For example, the fields that are indicated as IDs are represented with numbers in the Products table. I need it to display the actual data that is entered in the othe fields. Instead of color displaying as "3", I need it to tell me it's "red". How do I do this?

I can get one table to work but not 4. This is what I started with:

$result= mysql_query ("SELECT Products.colorID, Color.color
         FROM Products, Color
		 WHERE Products.colorID = Color.colorID") or
die (mysql_error());

Any help is appreciated. Thanks in advance for your help.

notaloser

SELECT PRODUCTS.description, TYPE.type, THEME.theme, COLOR.color, SIZE.size
FROM PRODUCTS
(INNER JOIN TYPE
ON PRODUCTS.typeID=TYPE.typeID)
INNER JOIN THEME
ON PRODUCTS.themeID=THEME.themeID
(INNER JOIN COLOR
ON PRODUCTS.colorID=COLOR.colorID)
INNER JOIN SIZE
ON PRODUCTS.sizeID=SIZE.sizeID

its a pretty complicated sql statement, i dont think i messed up 🙂

cbesh2

Thanks for the help, but it gave me an error:

You have an error in your SQL syntax. Check the manual that corresponds 
to your MySQL server version for the right syntax to use near '(INNER JOIN TYPE 
ON PRODUCTS.typeID=TYPE.typeID) INNER JOIN T

Any other suggestions?

Also, why does every other INNER JOIN statement have a parenthesis around it?

cbesh2

Got it! Here's what I came up with:

SELECT Products.description, Type.type, Theme.theme, Color.color, Size.size
FROM Products
INNER JOIN Type ON Products.typeID=Type.typeID
INNER JOIN Theme ON Products.themeID=Theme.themeID
INNER JOIN Color ON Products.colorID=Color.colorID
INNER JOIN Size ON Products.sizeID=Size.sizeID

Thanks again for your help!

notaloser

heh my bad i was using the parentheses to keep track of it while i wrote it. then forgot to get rid of them haha sorry

cbesh2

That's OK. Thanks for your help.