title: getting the value of the single field output using the codeigniter active record
body: <p>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"</p>
  
  <pre><code>function sban_name($asset){
      $this-&gt;db-&gt;select('name');
      $this-&gt;db-&gt;from('asset_types');
      $this-&gt;db-&gt;where('code',$asset);
      return $this-&gt;db-&gt;get()-&gt;result()-&gt;row('name');
  }
  </code></pre>
  
  <p>All I want is to have the name of the asset returned back to the controller! Your help is highly appreciated!</p>