Hi...All !
i am new to cake php i am writting query like this , i am using left join i
wrote the query like below, but i dont know how to display that fileds data
please help me out
$storeDivisions = $this->Store->find('all',
array('joins' =>
array(
array( 'table' => 'divisions',
'alias' => 'd',
'type' => 'left',
'foreignKey' => false,
'conditions'=> array('Store.division_id = d.division_id')
)
),
'conditions'=>array('d.country_id'=>1),
'order'=>array('Store.store_name ASC')
)
);
query is working but i am not able to display get divsions table data how to
retrive that data, i worte like this
foreach ($storeDivisions as & $storeDivision){
echo "Name :".$storeDivision['Store']['store_name']."; // here i
get result
echo "<br />Id :".$storeDivisions['d']['name']."<br/>"; // here
i didnt get the result,
}
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
