I have a trouble with AR

Yii 1.1 General Discussion
1

I have two table on database with:

tbl_user{

‘id’,‘user’

}

tbl_info_user{

‘id’,‘user_id’,‘status_id’

}

and :user_id is foreign key and references tbl_user table,

and i want to get all the columns in the tbl_user and the status column. i don’t know AR support to it?

2

Did you read the Definitive Guide to Yii ?

Here is the part that explains the relations - http://www.yiiframework.com/doc/guide/1.1/en/database.arr

3

Thank you !

I tried with the command line under but it not work.




     public function getAllData(){

            $criterial = new CDbCriteria();

            $criterial -> select =array('tbl_user.id','tbl_user.id','tbl_info status_id');

            $criterial -> with ='account';

            return $this::model()->findAll($criterial);

        }

can you give me an example with this case?

4

Do you have the relations declared ?

5

Yse i have a relations declared.