通过蛋糕获得从数据库的不同价值-php

Question

您好，我想从cakephp的特定列中获取不同的值。

这是我曾尝试： -

$new_data =$this->Event->findAll(null, 'DISTINCT events.source'); 

Event- is the name of my model. 
events- is my table name in db. 
Source:- is the column name from which i want to fetch values. 

我硝基甲苯KNW什么是错的查询，任何人都可以帮我

Answer 1

$this->Event->find('all', array('group' => 'Event.source')); 

Answer 2

findAll实际上不是一个CakePHP的方法。你想要做的是：

$this->Event->find('all', array('fields' => 'DISTINCT Event.source')); 

http://book.cakephp.org/2.0/en/models/retrieving-your-data.html#find-all

Answer 3

$this->Event->find('all', array('group' => 'Event.source'));