get data from maultiple table with relationships

shreyas · August 30, 2012, 12:26pm

Hello

I have data in 3 tables A,B and C, where two of the tables A,B are related to 3rd table C say location. so i want to get data from those two tables A and B in one controller it self. so i have created one model with first table A, there i am trying to make relation of the table B and C but the error comes as

Relation "cost_Location" is not defined in active record class "Costs". the code is as follows :

in controller

$criteria = new CDBCriteria;

	&#036;criteria-&gt;with=array('user_modifyby'=&gt;array('select'=&gt;'username') ,'cost_Location'=&gt;array('select'=&gt;'location_type')); //,'costLocation'=&gt;array('select'=&gt;'location_type'));


	&#036;arrCosts = Costs::model()-&gt;findAll(&#036;criteria);

In model

‘user_modifyby’=>array(self::BELONGS_TO, ‘Users’, ‘cost_creator’),

	'cost_Location'=&gt;array(self::BELONGS_TO, 'Locations', 'location_id'),


	);

For first relation it works but as soon as i try to relate 2nd table that is location it gives error. not getting where i am going wrong.

Thanks in advance.

softark · September 1, 2012, 3:01am

shreyas d:




$criteria = new CDBCriteria;

$criteria->with=array('user_modifyby'=>array('select'=>'username')

    ,'cost_Location'=>array('select'=>'location_type'));

    //,'costLocation'=>array('select'=>'location_type'));

$arrCosts = Costs::model()->findAll($criteria);




'user_modifyby'=>array(self::BELONGS_TO, 'Users', 'cost_creator'),

'cost_Location'=>array(self::BELONGS_TO, 'Locations', 'location_id'),

Um, I don’t see any flaw in your code … don’t you have any simple typo?