DB_DataObject Joins
| From: | Noel da Costa | Date: | Fri, 11 May 2007 13:52:35 +0000 |
| Subject: | DB_DataObject Joins | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-27274@lists.php.net to get a copy of this message | ||
Hi all,
Quick quizzle about DB_DataObject Joins...
Can I create a join on the same table?
For example:
$m =& DB_DataObject::factory('person');
$m->selectAdd();
$m->selectAdd('distinct email');
$f =& DB_DataObject::factory('person');
$m->joinAdd($f);
... so I'm trying to eliminate duplicate emails and then still return all the fields from that table.
Ideas?
Thanks,
Noel
Noel da Costa
Lead Developer
Magnet Harlequin
T: 01895 432400
M: 07879 427940
F: 01895 432444
E: noel.dacosta@magharl.co.uk
W: http://www.magharl.co.uk
This e-mail is intended solely for the addressees named above and any other
use is prohibited. Access to this email by anyone else is unauthorised. It
may contain confidential information. If you have received this e-mail in
error, please contact the sender by return e-mail. We do not accept legal
responsibility for the contents of this message if it has reached you via
the internet. Any opinions expressed are those of the author and are not
necessarily endorsed by the company. Recipients are advised to apply their
own virus check to this message and all incoming e-mail on delivery.