Yii Framework Forum: Replete Rows Collect Together In Gidview - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Replete Rows Collect Together In Gidview Rate Topic: -----

#1 User is offline   chamara 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 47
  • Joined: 05-June 13
  • Location:srilanka

Posted 14 June 2013 - 06:09 AM

i want to view same named( ex: first_name) only one time and wanted to add repeated column to together

i want to show users and it related roles in one line

join query

$criteria = new CDbCriteria;
$criteria->select = 't.id, a.itemname as role, t.first_name, t.username, t.email, t.address, t.tele';
$criteria->join = 'LEFT JOIN authassignment a ON t.id = a.userid LEFT JOIN authitem m ON m.name = a.itemname';
// $criteria->group = 't.first_name';
$criteria->order ='t.id';

Attached File(s)


0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users