codeigniter, get the maximum value in mysql table column codeigniter, get the maximum value in mysql table column codeigniter codeigniter

codeigniter, get the maximum value in mysql table column


Try:

$this->db->select_max('time_taken AS time');$result = $this->db->get('students')->row();  echo $result->time;

Edit: Make sure your database table field (i.e time_taken) is decimal, NOT integer.


$this->db->select_max('time_taken');$this->db->from('students');$query=$this->db->get();return $query->result_array();