my @rows;
while (my $result=$sth->fetchrow_hashref) {
    push (@rows, $result);
}