Hi ,

I have the odd situation where I can retrieve data from a HABTM model (from 
debug array)but cant actually display any of it in the view. I keep getting 
index undefined error for everything. I want data from both tables but it 
doesnt work


//view doesnt work
  foreach ($student as $item2):
           echo '<td>'. $item2['Lesson']['id'].'</td>';    
       echo '<td>'. $item2['Student']['first_name'].'</td>'; //error 
undefined index


//controler

class LessonsController extends AppController {

...
  $this->Lesson->recursive = -1;
     
            $options['joins'] = array(
               array('table' => 'lessons_students',
                'alias' => 'LessonsStudent',
                'type' => 'LEFT',
                'conditions' => array(
                'Lesson.id = LessonsStudent.lesson_id',
                 )
                 ),
                
                array('table' => 'students',
                'alias' => 'Student',
                'type' => 'LEFT',
                'conditions' => array(
                'LessonsStudent.student_id=Student.id',
                 )
                 ),
                        
            );
            
            $options['conditions'] = array('Student.id' => 2);
      //  $Item->find('all', $options);
            
     $student=$this->set( 'student',$this->Lesson->find('all', $options));

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

Reply via email to