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();