cakephp array's and find statement

Question

I have two find statements and need the results of one find statement to use in the second find statement however the two methods I have tried to use have come back with errors

here is the first find statement, it lists the sender_id's

$sender=$this->Invoice->Find('list', array('fields'=>('sender_id')));

here is the second find statement, it takes that list of sender_id's and returns the corresponding company_name

$senderName=$this->Account->Find('all', array(
        'conditions' => array(
        $sender=>'account.id')));

this returns the right information however returns this error Warning (2): Illegal offset type [APP\Controller\InvoicesController.php, line 185]

so i tried doing it this way

$senderName=$this->Account->Find('all', array(
        'conditions' => array(
        'id'=>$sender['Invoice']['sender_id'])));

and get an undefined index on invoice.

tigrang · Accepted Answer · 2012-08-15 07:25:18Z

1

$senderName=$this->Account->Find('all', array(
        'conditions' => array(
            'Account.id' => array_values($sender),
        ),
));

The key is the field and the value is, well, the value(s).

answered Aug 15, 2012 at 7:25

tigrang

6,7671 gold badge22 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

cakephp array's and find statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related