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