db->select('c.*,d.financial_type,a.financial_from_year,a.financial_to_year');
$this->db->from('financial_details c');
$this->db->join('financial_type d', 'd.financial_type_id =c.financial_type_id', 'left');
$this->db->join('financial_year a', 'a.financial_year_id =c.financial_year_id', 'left');
$this->db->group_by('c.financial_year_id');
$this->db->where('c.status', 1);
$sql = $this->db->get();
if ($sql->num_rows() > 0) {
foreach ($sql->result_array() as $row) {
$facilty_details = $row['financial_year_id'];
$academic_from_year = $row['financial_from_year'];
$financial_type = $row['financial_type'];
$academic_to_year = $row['financial_to_year'];
?>
" style="color:#3b8dcf;">Click here to view the financial details ( - )