[dameon51]

Hey everyone.

I'm doing a join with 3 tables, they all have a field called 'id'.

When I do a query straight to mysql it returns the id fields like

id, id1, id2

This is what I want.

I run the same query in php, and it only get

id

Which has the value of the id2, so its just taking the last id field.

Anyway to make it include the duplicate ones?

Thanks

[squibby]

please put up your query and let me see and i will try to help.

[dameon51]

SELECT products.*, product_gallery_map.*, image_gallery.* 
FROM products 
LEFT JOIN product_gallery_map ON product_gallery_map.productID=products.priKeyID 
LEFT JOIN image_gallery ON image_gallery.priKeyID=product_gallery_map.galleryID 
WHERE products.active= '1' ORDER BY products.ordinal

[Atli]

You can use aliases to set different names for columns and tables. For example:

SELECT
	p.id AS product_id,
	gm.id AS gallery_map_id,
	ig.id AS gallery_id
FROM product_table AS p
LEFT JOIN product_gallery_map AS gm
	ON gm.productID = p.id
LEFT JOIN image_gallery AS ig
	ON gm.galleryID = ig.id

[e_i_pi]

Selecting '*' is something you should avoid for many reasons, and this attribute namespace clash is one of them. There are very few instances where selecting * is both necessary and safe.

Following Atli's advice is your best bet, as it both resolves your problem, and is a good programming technique.