activerecord - getting the value of the single field output using the codeigniter active record

Question

the following function is supposed to read the name of the given asset code from the database. but it triggers the error: "Trying to get property of non-object"

function sban_name($asset){
    $this->db->select('name');
    $this->db->from('asset_types');
    $this->db->where('code',$asset);
    return $this->db->get()->result()->row('name');
}

All I want is to have the name of the asset returned back to the controller! Your help is highly appreciated!

Answer 1

Use row() like,

return $this->db->get()->row()->name;