Re^4: fetchall( )

[albert]

in reply to Re^3: fetchall( )
in thread fetchall( )

with something like this:

my $ref = $sth->fetchall_arrayref();

my $second_name = $ref->[1]->[1];

To iterate over all the results and print them, you could do:

my $ref = $sth->fetchall_arrayref();

foreach my $inner (@$ref){
     print join ("\t", @$inner), "\n";
}

-albert