my $sth = $dbh->prepare("SELECT * FROM $table");
$sth->execute;
while (my $array_ref = $sth->fetch) {
    #
    #do something
    #
}