phpactiverecordcodeigniter-2

How to use 'DISTINCT' in Codeigniter Active Records?


I have a query using active records.

$this->db->select('reg.users_id,reg.registration_id,reg.device_type');
$this->db->join('users as usr','usr.users_id = reg.users_id','left');
$this->db->where('usr.users_status',1);
$this->db->where('reg.users_id',91);
$query = $this->db->get('users_gcm_registration as reg');

I want to fetch DISTINCT(registration_id).

How can I do that?


Solution

  • You can use distinct(), but it's better to use group_by().

    $this->db->select('reg.users_id,reg.registration_id,reg.device_type');
    $this->db->join('users as usr', 'usr.users_id = reg.users_id', 'left');
    $this->db->where('usr.users_status', 1);
    $this->db->where('reg.users_id', 91);
    $this->db->group_by('reg.registration_id');// add group_by
    $query = $this->db->get('users_gcm_registration as reg');