DISTINCT Does not work as a keyword in codeigniter....

[eluser]solid9[/eluser]
not tested, but try this,


function getdetaildatabyid($id)
{
$this->db->select(“contact_details_id,contact_id,contact_value”);
$this->db->distinct('contact_type');
$this->db->from(“tbl_contact_details”);
$this->db->where(“tbl_contact_details.contact_id”,$id);
$query = $this->db->get();
$data = $query->result();
echo $this->db->last_query();die;
return $data;
}

or try this below,
function getdetaildatabyid($id)
{
$this->db->distinct('contact_type');
$this->db->from(“tbl_contact_details”);
$this->db->where(“tbl_contact_details.contact_id”,$id);
$query = $this->db->get();
$data = $query->result();
echo $this->db->last_query();die;
return $data;
}