How To Fetch The Data From Another Table Using Cdbcriteria And Cactivedataprovider?

Yii 1.1 General Discussion
1

Hello friends…

how to fetch the data from another table using CdbCriteria and CActiveDataProvider and this data will be display in view part in CListView?

pls help me.

which is appreciated for me…

thanks in advance…

2

Using relation name You can get the another table values ex. in Listview table2.name, table2.value

Bsourcecode

3

thanks mbala…

i am using this link…

[url="http://www.yiiframework.com/forum/index.php?/topic/15394-cactivedataprovider-and-join/"]

[/url]

My link

this is done properly after that in the view part another table data not come.

pls give me some suggestion…

4

i solved this problem…

i am using "with" in CActivedataprovider and CDbCriteria in controller…




$criteria = new CDbCriteria();

$dataProvider = new CActiveDataProvider('ProductIndex', array(

					'criteria' => array(

'with' => 'pricing',

'with' => 'masterKey',));

and in view part i use this…

$data->pricing->price