my $hash_ref = $dbh->selectall_hashref('select id, name, price from products', 'id' );
while ( my ($id,$value) = each %$hash_ref ) {
	my $name = $value->{name};
    my $price = $value->{price};
	# ...
}