fetch query result

$sql = "SELECT * from user WHERE s_user_account = '".$account."'";
$query = $this->db->query($sql);

return $query ://只送回query的第一筆資料,需要搭配query->row_array()才能 praser出array
CI_DB_mysql_result Object ( [conn_id] => Resource id #25 [result_id] => Resource id #28 [result_array] => Array ( ) [result_object] => Array ( ) [current_row] => 0 [num_rows] => 0 )

return $query -> result: ://送回query的全部資料
Array (
[0] => stdClass Object ( [id] => 1 [member_id] => 9 [group_id] => 1 [s_role] => u [approver_id] => 8 )
//////////////////////////////////
[1] => stdClass Object ( [id] => 3 [member_id] => 9 [group_id] => 2 [s_role] => u [approver_id] => 8 )
[2] => stdClass Object ( [id] => 5 [member_id] => 9 [group_id] => 3 [s_role] => u [approver_id] => 8 )
[3] => stdClass Object ( [id] => 7 [member_id] => 9 [group_id] => 4 [s_role] => u [approver_id] => 8 )
)

return $query
$user = $query->row_array();
Array ( [id] => 9 [s_user_account] => windharry [s_password] => windharry [n_shard] => 1 [n_hash] => 34 [s_email] => windharry@mail.com [s_blog_title] => [d_create_time] => 2007-05-23 16:25:28 [d_update_time] => 2007-05-23 16:25:28 )