ActiveRecord + CodeIgniter - Return single value from query, not in array form

php sql activerecord codeigniter

$query = $this->db->get(); // your ActiveRecord query that will return a col called 'sum'echo $query->row('sum');

php sql activerecord codeigniter

$output = $this->db->query("YOUR QUERY")->row()->fieldname;

$output = $this->db->get("TABLE NAME")->row()->fieldname;

Where fieldname is the name of the field you want the output of in your query.

php sql activerecord codeigniter

this isn't the prettiest way. i can't find a way to do it with the active record api. but here's a one-liner to get it.

$result = array(    array('sum' => '23'));echo current( current( $result ) );

CodeHunter