title: codeigniter select as
body: <p>how doHow do we do 
      <code>select table.value as table_value from table</code> in codeigniter?<br>
  The <code>AS</code> part doesnt work because when i try to access the value, 
  this doesnt work:</p>
  
  <pre><code>    $qry_inp =  'select table.value as table_value from table '
      $query = $this-&gt;db-&gt;query($qry_inp); 
  
      echo $query-&gt;row('table_value ');// this will be empty, but it shouldn`t be
  </code></pre>
  
  <p>doesn`t matter if its in AR or simple query</p>