I have three tables : actor, film_actor, film. The fields are:
actor:
actor_id(primary key)
first_name
last_name
film_actor:
actor_id,film_id(primary key)
film:
film_id(primary key)
title
description
In the Actor model I have the relations:
‘filmactors’ => array(self::HAS_MANY, ‘FilmActor’, ‘actor_id’),
‘films’ => array(self::HAS_MANY, ‘Film’, ‘film_id’, ‘through’ => ‘filmactors’),
In the View of Actor for an actor_id I have
$dataProvider=new CActiveDataProvider(‘Film’);
$dataProvider->getData();
$this->widget(‘zii.widgets.grid.CGridView’, array(
'dataProvider'=>$dataProvider,
'columns'=>array('film_id','title','description')
));
In Film model I have the following relations:
‘hasFilmActors’ => array(self::HAS_MANY, ‘FilmActor’, ‘film_id’),
‘actors’ => array(self::HAS_MANY, ‘actor’, ‘actor_id’, ‘through’ => ‘hasFilmActors’),
This shows all films. I want to show only the films pertaining to the selected actor.
Can somebody suggest a solution?