[CakePHP]cakephp中group by的用法

Submitted by Derick Ng on 23 April 2009 - 11:51am

$params = array(
‘fields’ => array(’user_id’, ‘tag_id’, ‘num’),
‘conditions’ => array(’UserTag.tag_id’ => $getParams['id']),
‘group’ => ‘UserTag.user_id, UserTag.tag_id, UserTag.num, Tag.id, Tag.name, Tag.type_id, Tag.num, User.id, User.loginname, User.username, User.password, User.pic, User.system_list, User.status’,
‘recursive’ => 2,
);

$usersTags = $this->UserTag->find(’all’, $params);

在find参数里面的group需要写出所有表的所有需要获取的字段名，包括关联表