i’m still trying to get the GROUP_CONCAT function working. but <?php echo $daytrip->rTag->gTags; ?> remains empty.
hope you can help me out?
model Daytrip:
public function relations()
{
return array(
'rCity' => array(self::BELONGS_TO, 'City', 'CityId'),
'rTag' => array(self::MANY_MANY, 'Tag', 'DaytripTag(DaytripId, TagId)',
'select' => array('GROUP_CONCAT(Tag) AS gTags')),
);
}
view Daytrip:
<tr valign="top">
<td><?php echo $daytrip->IdDaytrip; ?></td>
<td><?php echo $daytrip->Daytrip; ?></td>
<td><?php echo $daytrip->rCity->City; ?></td>
<td>-<?php echo $daytrip->rTag->gTags; ?>-</td>
<td><?php echo date('j M Y', strtotime($daytrip->Modified)); ?></td>
</tr>
controller Daytrip:
$daytrips = Daytrip::model()->with('rCity', 'rTag')->findAll($criteria);