Hi,

I just want to clearify what Mohamed wrote. You should use the $table->select() method to get the $select variable. This is an instance of Zend_Db_Table_Select, what you can give as parameter to all the fetch methods of Zend_Db_Table.

Some code:

$select = $table->select();

$select->where('public=?', 1);

$rowset = $row->findManyToManyRowset('tbl_2', 'intersection_tbl', null, null, $select);

Regards,

Pieter Kokx

Mohamed Jadelrab schreef:
Hello Aljosa,

you can use

$row->findManyToManyRowset('tbl_2', 'Intersection_tbl', Null, Null, $select);
and in select do the query you want where public = 1..

Regards,

On Jan 30, 2008 3:47 PM, Aljosa Mohorovic <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:

    if i have:
    - tbl_1
    - tbl_2
    - intersection_tbl

    with:
    $items = $tbl_1_item->findManyToManyRowset('tbl_2',
    'intersection_tbl');

    result is as expected but how can i add "filter" so that $items
    contains only rows from tbl_2 with column "public=1"?

    Aljosa




--
Mohamed Jadelrab

Reply via email to