# loop through rows
while ($hashref = $sth->fethrow_hashref()) {
   push @$myarrayref , $hashref;
}