Yii AR unable to get the query value, need help

Yii 1.1 General Discussion
1

Hi All,

i have a query on 2 table, payment_configuration_info and payment_configuration_info_description and the relationship for payment_configuration_info to payment_configuration_info_description is HAS_MANY, below is the relationship:




public function relations()

	{

		return array(

		'payment_configuration_info_description'=>array(self::HAS_MANY, 'PaymentConfigurationInfoDescription','','on'=>'payment_configuration_info_description.payment_configuration_info_id = t.payment_configuration_info_id','joinType'=>'LEFT JOIN','alias' => 'payment_configuration_info_description'),

		);

	}

And here was my query in the payment_configuration_info models




$paymentId = '25';

		$langId ='1';

		$criteria=new CDbCriteria;

		$criteria->select = 'payment_configuration_info_title';

		$criteria->condition = 'payment_methods_id = :paymentId';

		$criteria->with = array('payment_configuration_info_description'=>array('select'=>'languages_id,payment_configuration_info_value',

																					'condition'=>'languages_id = :langId',

																					'params'=>array(':langId'=>$langId)

																					));

		$criteria->params = array(':paymentId'=>$paymentId);

		$result = $this->model()->findAll($criteria);

In the end, i have print_r($result) and i can see the payment_configuration_info_value is there but i not able to pull the data out, below was part of the print_r output.





 [payment_configuration_info_description] => Array

                        (

                            [0] => PaymentConfigurationInfoDescription Object

                                (


.....




  [_attributes:private] => Array

                                        (

                                            [languages_id] => 1

                                            [payment_configuration_info_value] => 1

                                            [payment_configuration_info_id] => 39

                                        )

I was using this script to pull the data:




		foreach($result as $test){

			$a[] = $test['payment_configuration_info_description'][0]['payment_configuration_info_value'];

		}

is there any problem to my script?

2

Hi

your first table data display like $data->FirstTableFieldName

And

second table data liek $data->SecondTableName->SecondTableFieldName

Thanks