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?

Replies are listed 'Best First'.
Re^4: fetchall( )
by albert (Monk) on Apr 22, 2005 at 09:39 UTC
    with something like this: 
    my $ref = $sth->fetchall_arrayref();

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

    [download]
    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";
}

    [download]
    -albert
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom