# Create statement handle
$sth = $dbh->prepare($somesql);

# execute statement handle
$sth->execute();

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

# clean up statement handle
$sth->finish();