LEFT JOIN returning arrays

[Shit4Brains]

hi all,

im using a join to return some values. Ive got 2 tables, one which is a products table, and the other is a colours table. The colors table stores a list of colors and the product id of the products which are available in that colour.. eg

PRODUCT: 'Chestpiece'
COLORS: White, Black

heres my sql to get the stuff:

	$sql = "SELECT tbl_products.product_title as title, tbl_colors.color_name as colors 
			FROM tbl_products 
			LEFT JOIN tbl_colors 
			ON tbl_products.product_id = tbl_colors.color_owner";

all it returns is one of the colors. how can i get it to return both?

[jdorsch]

Are you sure its not returning both colors? Your query is setup correctly. It will however return each color in its own row like

title color
chestpiece White
chestpiece Black

[Shit4Brains]

actually, yes its printing out them all. 🙂