in reply to Re^4: multidimensional array's
in thread multidimensional array's

If you do not need the @allrows array, it is wasteful to store data into it. Try this instead: 
my $loopcount = 0;
while (my $row =  $sth->fetchrow_arrayref() ) {
    my $title1 = $row->[1];
        print "$title1\n";
    $loopcount++;
};

my $titlesfound = $loopcount;

[download]

             "By three methods we may learn wisdom: First, by reflection, which is noblest; Second, by imitation, which is easiest; and third by experience, which is the bitterest."           -Confucius

In Section Seekers of Perl Wisdom