Type this: die(debug($storeDivisions));
...just before you try to access it, and you'll see its shape. Jeremy Burns [email protected] On 19 May 2010, at 13:54, Narendra Padala wrote: > 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 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
