[Active Record] Select AS Backticks problem

[eluser]Azhari Harahap[/eluser]
Finally get it working with little addition to the AR class.

Code:

// --------------------------------------------------------------------

    /**
     * Select AS
     *
     * Generates the SELECT(field AS) portion of the query
     *
     * @access    public
     * @param    string
     * @return    object
     */
    function select_as($select = '', $alias = '')
    {        
        if ( ! is_string($select) OR $select == '')
        {
            $this->display_error('db_invalid_query');
        }

        if ( ! is_string($alias) OR $alias == '')
        {
            $this->display_error('db_invalid_query');
        }        

        $sql = $this->_protect_identifiers(trim($select)).' AS '.$this->_protect_identifiers(trim($alias));

        $this->ar_select[] = $sql;
        
        if ($this->ar_caching === TRUE)
        {
            $this->ar_cache_select[] = $sql;
            $this->ar_cache_exists[] = 'select';
        }        

        return $this;
    }

And then you can do this:

Code:

$this->db->select_as('Name', 'GroupName');

It will produce:

Code:

SELECT `Name` as `GroupName` FROM (`pbk`)