zii.widgets.grid.CGridView many-to-many show

Yii 1.1 General Discussion
1

Hi All!

I’m a beginner and need help in simple, I hope things.

I have ‘book’ and ‘author’ tables and many-to-many relationship between them (‘book_has_author’ table).

In authors/admin action I want see column which book’s title for any authors.

A have:




 $this->widget('zii.widgets.grid.CGridView', array(

	'id'=>'author-grid',

	'dataProvider'=>$model->search(),

	'filter'=>$model,

	'columns'=>array(

		'id',

		'name',

		'second_name',

		array(

			'class'=>'CButtonColumn',

		),

                'books.title',

	),

))

but it not works.

Help my please. Maybe is some tutorial about relations in Yii?

2

http://www.yiiframew…en/database.arr

http://www.yiiframew…l-in-cgridview/

http://www.yiiframew…related-models/

3

Mayby I stupid but I still don’t know how do it. :(

4

yii manual is more … more see

but don’t tell what why when

when i read it i think what hell on it

it model / field name / variable

why don’t create full detail manual

or make full cms for example

5

Another wiki article about that: Displaying, sorting and filtering HasMany & ManyMany relations in CGridView