如何从查询中提取数据库信息？

Question

I can't seem to find the documentation laying this out clearly.

public function get_user_id_from_username($username){

    $this->db->where('username', $username);
    $this->db->select('id');
    $query = $this->db->get('users');

}

Quite simply, I want to return the id that I have just selected from the database. Can anyway tell me how I get access to that id?

Thanks.

Answer 1

The manual was very enlightening

$row = $query->row();
echo $row->id;