Hi, Nobody can help me out???
Regards On Apr 26, 1:25 am, jackgoh <[email protected]> wrote: > Hi, > > I am facing some problem when deal with a realtionship tables, the > record is not display : > > // in Stock model: > var $hasAndBelongsToMany = array( > 'Category' => array( > 'className' => 'Category', > 'joinTable' => 'category', > 'foreignKey' => 'stock_id', > 'associationForeignKey' => category_id', > 'with' => 'StockCategory', > ), > ); > > // in Stock controller: > $selectedRecord = $this->Stock->StockCategory->find('list', > array( 'fields'=>array('stock_id','category_id'), > 'conditions'=>array('stock_id='.$this->Stock->id) ) ); > $this->set(compact('selectedRecord')); > > I try to copy the SQL by using debug() to phpmysql, and i get 3 lines > of records. but when i try to PRINT_R the $selectedRecord, i can only > get 1 record, example: > > Array > ( > [1] => 4 > ) > > Suppose the result have to be : > > Array > ( > [1] => 4 > [1] => 7 > [1] => 14 > ) > > Values : 4,7,14 are category_id, [1] is stock_id. There is a table > call "category" to store all the category name. > > Please point out whats wrong to my code or logic?? > > Thanks > > Best Regards. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
