Help on $this->db->distinct() in a model

Help on $this->db->distinct() in a model - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Help on $this->db->distinct() in a model (/showthread.php?tid=38406)

Help on $this->db->distinct() in a model - El Forum - 02-07-2011

[eluser]Juan Velandia[/eluser]
Hello people.

I would like to replace this model

Code:
function get_date_status()  

     {

       $this->db->select('date_saldo');

       $this->db->group_by('date_saldo');

       $query = $this->db->get('con_unit_status');

       return $query->result();

       }

For something like

Code:
function get_date_status()  

     {

       $this->db->distinct('date_saldo');

       $query = $this->db->get('con_unit_status');

       return $query->result();

       }

But it doesn't seem to work, any ideas. Thanks in advance!

Help on $this->db->distinct() in a model - El Forum - 02-07-2011

[eluser]Rok Biderman[/eluser]
The distinct in AR is passed without arguments, so it would look something like this:

Code:
$this->db->distinct();

$this->db->select('oseba');

$query = $this->db->get('postavke');

return $query->result();

If you need further explanation, try and read:

http://ellislab.com/forums/viewthread/157238/

or try this:

http://ellislab.com/forums/viewthread/57781/

Help on $this->db->distinct() in a model - El Forum - 02-07-2011

[eluser]Juan Velandia[/eluser]
Thanks Coccodrillo! best regards!