DB_DataObject linking 3 tables to make an N - N relation.
| From: | luca at llucax dot hn dot org | Date: | Fri, 21 Jan 2005 19:41:36 +0000 |
| Subject: | DB_DataObject linking 3 tables to make an N - N relation. | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-17089@lists.php.net to get a copy of this message | ||
Hi! I'm relative new to DB_DataObject and I have a simple database with
an N to N relation, something like:
table1 table2 table1_table2
------ ------ -------------
id1 id2 id1
stuff1 stuff2 id2
I'd like to get all table1 items that belongs to a table2 item (eventually
adding a filter, like stuff1 > 5, but this is secondary). Is there any way
of doing this without messing up with SQL?
I can't find it anywhere and I think is a relative common case...
Any suggestions are welcome!
PS: Please Cc, I'm not in the list.
--
LUCA - Leandro Lucarella - JID: luca(en)lugmen.org.ar - Debian GNU/Linux
.------------------------------------------------------------------------,
\ GPG: B08B4FB2 // D9E1 4545 0F4B 7928 E82C 375D 4B02 0FE0 B08B 4FB2 /
'--------------------------------------------------------------------'
<muBarder> Y vos, Nw2o? A vos no te conozco pero debes ser flor de bala!
<[WA]BlkS> deja de joder
<muBarder> Vos cerra el culo, [WA]BlkS!