#execute statement here
my @data = (); # define an array
while(my $row = $sth->fetchrow_hashref()) {
     push(@data,$row);
}

# finish and disconnect

##</code><code>##

my $field_1 = $data[0]->{'field_1'};