Change data retrieved from model in controller

[eluser]pyrokinesis[/eluser]
Hi kgill,

There are no spaces in the table names or any spaces in any of the columns in the table.
They tried to get in, and were willing to pay extra but I didn't let them in.

Code:

function get_data() {
    $query =
            "SELECT
                staff_id AS 'Staff ID',
                name AS 'Name',
                email_address AS 'Email Address',
            FROM staff
            ";
    return $this->db->query($query);
}

When the query is returned the stdobject uses the column aliases.