in reply to fetchall( )

But i want to save the data all in a array or something. Because i need to compare it with itself. So i need all the data to be safed. So i can acces it later on. Like a 2d array

Replies are listed 'Best First'.
Re^2: fetchall( )
by Jasper (Chaplain) on Apr 21, 2005 at 14:25 UTC
    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]
[reply]
[d/l]
      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]
        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