Re^3: fetchall( )

[maarten_m4]

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

than i would have something like this: row1: name, adress, place row2: name, adress, place row3: name, adress, place And how do i select by example only the name of row 2?

[albert]

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