Re^2: loop though query results twice

I looked online and I am having trouble understanding the fetchall_array command, and how it works, can you use it in the example I gave?

Comment on Re^2: loop though query results twice

Replies are listed 'Best First'.
Re^3: loop though query results twice by Anonymous Monk on Apr 28, 2009 at 13:18 UTC
`my $tbl_ary_ref = $query1->fetchall_arrayref; warn "WHOOPS ", $query1->err if $query1->err ; for my $data ( @{ $tbl_ary_ref } ){ my $cur_company = $$data[0]; $cur_company = $data->[0]; ... } for my $data ( @{ $tbl_ary_ref } ){ my $cur_company = $$data[0]; $cur_company = $data->[0]; ... } for my $data ( @{ $tbl_ary_ref } ){ my $cur_company = $$data[0]; $cur_company = $data->[0]; ... }` [download] references quick reference	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: loop though query results twice
by Anonymous Monk on Apr 28, 2009 at 13:18 UTC

my $tbl_ary_ref = $query1->fetchall_arrayref;
warn "WHOOPS ", $query1->err if $query1->err ;

for my $data ( @{ $tbl_ary_ref  } ){
    my $cur_company = $$data[0];
    $cur_company = $data->[0];
...
}

for my $data ( @{ $tbl_ary_ref  } ){
    my $cur_company = $$data[0];
    $cur_company = $data->[0];
...
}


for my $data ( @{ $tbl_ary_ref  } ){
    my $cur_company = $$data[0];
    $cur_company = $data->[0];
...
}
[download]

references quick reference

[reply]
[d/l]