codeigniter select as

Question

how doHow do we do select table.value as table_value from table in codeigniter?
The AS part doesnt work because when i try to access the value, this doesnt work:

    $qry_inp =  'select table.value as table_value from table '
    $query = $this->db->query($qry_inp); 

    echo $query->row('table_value ');// this will be empty, but it shouldn`t be

doesn`t matter if its in AR or simple query

Answer 1

Pretty simple thing.

$this->db->select('COLUMN_ACTUAL_NAME as `COLUMN_NAME_YOU_WANT_TO_SHOW`');