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

[eluser]aquary[/eluser]
What version of CI you are using? I remember in the old version I cannot use result() directly if there is no data.

Try this one and let see what are returned:

Code:

function getdetaildatabyid($id)
{
  $data=$this->db->select(“DISTINC contact_details_id,contact_id,contact_value”, FALSE)
     ->from(“tbl_contact_details”)
     ->where(“tbl_contact_details.contact_id”,$id)
     ->get();
  var_dump($data);
  // Maybe you could use these commented lines instead.
  // if($data->num_rows()>0)
  //    return $data->result();
  // else
  //    return array();
  return $data->result();
}