Im trying to get an max value with codeigniter from an table but it isnt working. This is the error i get:
Severity: 4096
Message: Object of class CI_DB_mysql_result could not be converted to string
Filename: database/DB_active_rec.php
Line Number: 427
This is my function:
public function getPeriodeNummer($bedrijf_id) { $this->db->select_max('id'); $this->db->where('bedrijf_id', $bedrijf_id); $result = $this->db->get('rapporten'); $this->db->select('periode_nummer'); $this->db->where('rapporten_id', $result); $query = $this->db->get('statistieken_onderhoud'); $data = $query + 1; return $data; }
What im trying to do is as followed:
- Select the highest
id
wherebedrijf_id
=$bedrijf_id
fromrapporten
. - Select the
periode_nummer
fromstatistieken_onderhoud
whererapporten_id
= the highestid
i got from step 1. - Add 1 to the
periode_nummer
i got from step 2 andreturn
that number.
Thanks in forward for your help!
Advertisement
Answer
Try
public function getPeriodeNummer($bedrijf_id) { $this->db->select_max('id'); $this->db->where('bedrijf_id', $bedrijf_id); $res1 = $this->db->get('rapporten'); if ($res1->num_rows() > 0) { $res2 = $res1->result_array(); $result = $res2[0]['id']; $this->db->select('periode_nummer'); $this->db->where('rapporten_id', $result); $query = $this->db->get('statistieken_onderhoud'); if ($query->num_rows() > 0) { $row = $query->result_array(); $data['query'] = 1 + $row[0]['periode_nummer']; } return $data['query']; } return NULL; }