Welcome Guest, Not a member yet? Register   Sign In
Active records Distinct() Problem
#1

[eluser]Radiart[/eluser]
Code:
$this->db->distinct();
$this->db->select('content.title, comments.id_usera, comments.id_content, comments.id_content_type, comments.created_date');
$this->db->join('content', 'content.id_content = comments.id_content');
$this->db->group_by(array('created_date','id_content_type','id_content'));
$this->db->orderby('comments.created_date', "desc");
$this->db->limit(10);
$query = $this->db->get($this->table_name);
$result = $query->result();
return $result;

Why distinct not working?

Quote: * HIP HOP GROOVE FESTIVAL 2010 radi
* HIP HOP GROOVE FESTIVAL 2010 radi
* WinterJam Party 2008 radi
* Wirująca Strefa 2010 Bboying radi
* I Śląski Przegląd Spektakli Tańca… radi
* Wirująca Strefa 2010 Bboying
* Letnie Kursy Taneczne z uczestnikami…
* I Śląski Przegląd Spektakli Tańca…
* FNF SUPER SUMMER DANCE INTENSIVE 2010…
* FNF SUPER SUMMER DANCE INTENSIVE 2010…


Messages In This Thread
Active records Distinct() Problem - by El Forum - 12-29-2010, 07:00 AM
Active records Distinct() Problem - by El Forum - 12-29-2010, 07:42 AM
Active records Distinct() Problem - by El Forum - 12-29-2010, 08:00 AM
Active records Distinct() Problem - by El Forum - 12-29-2010, 08:24 AM
Active records Distinct() Problem - by El Forum - 01-02-2011, 07:45 AM
Active records Distinct() Problem - by El Forum - 01-23-2011, 11:02 PM



Theme © iAndrew 2016 - Forum software by © MyBB