Problem To Showing Data From 2 Tables In Clistview

Yii 1.1 General Discussion
1

hi guys,

I’m in a trap. I use below code for my CListView. i did not found my fast_name, and last_name column in my returned variable $dataProvider.


$criteria = new CDbCriteria(array(

				'alias'=>'meal_expenses',

				'select' => 'meal_expenses_id, expense_by, first_name, last_name, grant_total, received_datetime',

				'join' => 'INNER JOIN member ON member.member_id=expense_by',

				'condition'=>'member.mess_id=:mess_id and member.is_active=:isActive',

				'params'=>array(':mess_id'=>Yii::app()->user->mess_id, ':isActive'=>1),

		));

		

		$dataProvider =  new CActiveDataProvider($this, array(

				'criteria'=>$criteria,

		));

		

		return $dataProvider;

please help me…

Thanks

2

Maybe in your select use member.first_name, member.last_name

I would use a relation definition in the model and drop your join an use a ‘with’=> and ‘together’=> instead

3

Thank you for your reply. I used “member.first_name, member.last_name” after you reply but I am sorry to say that there is no first_name and last_name column in my $dataProvider variable :(.

I am very very beginner in Yii so if possible please give me an example for this code.

Thanks a lot

4

What table is first_name, last_name in?

What is the output from print_r($dataProvider)?

Do you have any relations on these tables?

5

member.member_id, member.first_name, member.last_name coming from member table.

no there is no relation. but i have member_id in my meal table.

there is no record from member table in my output variable $dataProvider.