title: CodeIgniter - return only one row?
body: <p>At the moment if I am doing a query on the database that should only return one row, using:</p>
  
  <pre><code>...query stuff...
  $query = $this-&gt;db-&gt;get();
  $ret = $query-&gt;result();
  return $ret[0]-&gt;campaign_id;
  </code></pre>
  
  <p>Is there a CodeIgniter function to return the first row?
  something like <code>$query-&gt;row();</code></p>
  
  <p>Or even better would be the ability to, if there was only one row,
  to just use the query object directly.</p>
  
  <p>e.g. <code>$query-&gt;campaign_id;</code></p>