CI->db->select('username')->from( $this->CI->config->item('AUTH_table_prefix')."user_temp" )->where('id', $ci_user_id); $username = $this->CI->db->get()->row()->username; // I'm used to doing: $username = $db->getOne("SELECT username FROM foo WHERE id=1");