CODE EXAMPLE FOR PHP

return only one column data from table in codeigniter

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