[GeneralVini]

I have the following tables in my database:

tick
|idTick|idTema

tema
|idTema|nomeTema

tick.idTema is a foreign key to tema.idTema

The code

$dataProvider=new CActiveDataProvider('Tick');
$this->widget('zii.widgets.grid.CGridView', array(
    'dataProvider'=>$dataProvider,
    'columns'=>array(
        'idtick',         
        'idtema',  
        array(            
            'class'=>'CButtonColumn',
        ),
    ),
));

How can i show nomeTema in the grid

thxs !!!

[tri]

GeneralVini, on 05 July 2010 - 09:40 AM, said:

I have the following tables in my database:

tick
|idTick|idTema

tema
|idTema|nomeTema

tick.idTema is a foreign key to tema.idTema

The code

$dataProvider=new CActiveDataProvider('Tick');
$this->widget('zii.widgets.grid.CGridView', array(
    'dataProvider'=>$dataProvider,
    'columns'=>array(
        'idtick',         
        'idtema',  
        array(            
            'class'=>'CButtonColumn',
        ),
    ),
));

How can i show nomeTema in the grid

thxs !!!

Declare a relation in the Tick model e.g call it rtema. Then use rtema.nomeTema in the grid.

More info on relation here
http://www.yiiframew...de/database.arr

/Tommy

[Joe Storm]

I think you will have to get the dataProvider sorted out in the controller.. i.e joining the tables..