Re: DB_DataObject 2 joins to same table
| From: | Michael Wallner | Date: | Tue, 30 Nov 2004 08:37:13 +0000 |
| Subject: | Re: DB_DataObject 2 joins to same table | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-15918@lists.php.net to get a copy of this message | ||
Hi <...>, you wrote:
> Hi!,
>
> Hi have a tables relationship like the
> 'Automatic Table Linking and Joins' example at PEAR DB_DAtaObject
> Documentation. One table that have two columns that links to the same
> table and the same column. For example:
> Thanks about any help.
Just join the same dataobject again, with another name:
$authors = DAO::factory('users');
$posters = DAO::factory('users');
$article = DAO::factory('posts');
$article->joinAdd($authors);
$article->joinAdd($posters, 'INNER', 'posters');
Regards,
--
Michael - < mike(@)php.net >
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc