public function get_all_candidates_info(){

    $this->db->select('*');        // select all columns
    $this->db->from('candidates'); // FROM table
    $this->db->join('work_experiences', 'work_experiences.candidate_id = candidates.id','left'); // INNER JOIN
    $this->db->join('skills', 'skills.candidate_id = candidates.id','left'); // INNER JOIN
    $this->db->join('educations', 'educations.candidate_id = candidates.id','left'); // INNER JOIN
    $query = $this->db->get(); // GET RESULT

    $result = $query->result_array();

    //return $result;



    $newArray = array();
    foreach ($result as $key => $value) {
        $newArray[$value['first_name']."asdasds"][] = $value; // sort as per candidate name
    }


    foreach ($newArray as $key => $value) {
    echo $key."<br/>"; // print Category Name
    foreach ($value as $final_value) {

        echo $final_value['skill_name']."<br/>"; // print all items against category
         echo $final_value['education_provider']."<br/>"; // print all items against category
          echo $final_value['company_name']."<br/>"; // print all items against category

    }
}