Look at something like this. It will fetch all the rows ( assuming no errors ) and put them in a reference to an array of arrays.

my $sth = $dbh->prepare( 'SELECT * FROM tbl');
$sth->execute()
my $arrayRef = $sth->fetchall_arrayref([]);
[download]