Re^2: fetchall( )

When you do a fetchall_arrayref, that returns a reference to what is essentially a 2d array.

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

gives:

$ref   [
          [row of 1st data in here],
          [2nd row data here],
          [3rd row of data here]
       ]
[download]

Comment on Re^2: fetchall( ) Download Code

Replies are listed 'Best First'.
Re^3: fetchall( ) by maarten_m4 (Initiate) on Apr 21, 2005 at 16:43 UTC
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?	[reply]
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]