Bug #9815

mistake(?) in PEAR joinAdd Documentation

Details

Doc Bug #9815	mistake(?) in PEAR joinAdd Documentation
Submitted	2007-01-12 16:56 UTC
From	msohmen at web dot de
Assigned	cellog
Status	Closed
Package	DB_DataObject
PHP Version	5.2.0
OS	Linux
Roadmaps	(Not assigned)

Comments

[2007-01-12 16:56 UTC] msohmen at web dot de

Description:
------------
In the PEAR Documentation seems to be a mistake:
- function joinAdd, example for join result, original:

SELECT * FROM image,product_image
LEFT JOIN image ON product_image
LEFT JOIN image ON productgroup_image
WHERE product
AND product.id = product_image.pid
AND product.id = productgroup_image.pid

The "where" condition in this case should be
WHERE image.id = product_image.pid
AND image.id = productgroup_image.pid
I think

Yours, Michael