Update: Whoops, my bad, that'll teach me not to read the question properly. VSarkiss is correct and thanks for pointing it out :)

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

And if you're not you should probably check that your query executes too :)