Re: pushing individual rows of return (DBI) into seperate arrays

Why not just use an array of arrays.

$sth->execute() or die $sth->errstr;

my @result_arrays;
while (my @result = $sth->fetchrow_array()) { 
  push(@result_arrays, \@results);        
}

foreach(@results_arrays){  
  print qq(@{$_}<br><br>);
} 
$sth->finish();
[download]

Comment on Re: pushing individual rows of return (DBI) into seperate arrays Download Code

Replies are listed 'Best First'.
•Re: Re: pushing individual rows of return (DBI) into seperate arrays by merlyn (Sage) on Aug 29, 2003 at 13:51 UTC
And then, why not use the built-in tool to do that: `$sth->execute; # I always set RaiseError so I don't have to keep sayin +g "or die..." my $result = $sth->fetchall_arrayref(); # calls ->finish too for (@$result) { print qq{@$_<br><br>}; }` [download] -- Randal L. Schwartz, Perl hacker Be sure to read my standard disclaimer if this is a reply.	[reply] [d/l]