[samilo]

Hi

I need to know how to call relationship in listData() ,

For Example in normal way we can call it like :

$model->section->section_name ;

in my code i just print value as number but I need to print string value from courses table .

   public function coursesList($section_id) {
    	
    	
    	$data=Msection::model()->findAll('section_id=:section_id', 
              	array(':section_id'=>(int)$section_id));
          	
              	
    	return CHtml::listData($data,'course_id','course_id');
 //// can i call it like : ///listData($data,'course_id->course->course_name','course_id');
	}

Can I call it like?

listData($data,'course_id->course->course_name','course_id');

How To fix that ?

thanks in advance

[PeRoChAk]

Yes, you can do it as

listData($data,'course.course_name','course_id');

where course is a relation.

Further Value funcion

[samilo]

Thanks PeRoChAk but Not Work , This is my relations , it's just print course_id when use your code

public function relations()
	{
		// NOTE: you may need to adjust the relation name and the related
		// class name for the relations automatically generated below.
		return array(
			'section' => array(self::BELONGS_TO, 'Csection', 'section_id'),
			'course' => array(self::BELONGS_TO, 'Courses', 'course_id'),
		);
	}

[PeRoChAk]

Can you show your code here

[seenivasan]

Dear Friend
I think what PeRoChAk suggested should work.

Else Kindly check the following in your case please.

$sections=Msection::model()->findAll('section_id=:section_id', array(':section_id'=>(int)$section_id));

CHtml::listData($sections,function($section){ //You can pass the anonymous functions from second parameter on wards.
       return CHtml::encode($section->course->course_name);
                                            },'course_id');

Regards.

[samilo]

OK , Thanks