fetchrow_array loading an array in an array ?

[letsGo123]

i'm trying to populate an array with a reference to array returned by:fetchrow_array so that I can use the values more than once during in script

$counter = 0;
foreach $addedProduct (@cartData)
{

 my $query = "Select column1, column2, column3, column4, column5, column6, column7 from tableName where  id ='$id_value'";

 $sth = $dbh->prepare($query);

 if (!$sth) { die "Illegal query: $query" };

 $sth ->execute;
 while (@row = $sth->fetchrow_array) {
  @rowResults[$counter] = @row;
 }
 $sth->finish; 
 
 $counter=$counter+1; 
}

if i then:
print "$rowResults[0]<p>";
print "$rowResults[1]<p>";
print "$rowResults[2]<p>";

the results that are printed are only the first column of each row. not sure why the other 6 columns are not being populated into the array.

any help would be helpful. thanks.

 

[PaulTEG]

$rowResults[$counter]=@row;

No ..?

--Paul

 

[letsGo123]

paul - thanks for the reply:

but:
$rowResults[$counter] = @row;

& then:
print "@rowResults<p>";
print "$rowResults[0]<p>";
print "$rowResults[1]<p>";
print "$rowResults[2]<p>";

returns:
7 7 7
7
7
7

which is the size of @row.

 

[PaulTEG]

My mistake, lack of carbs ...

 while (@row = $sth->fetchrow_array) {
  foreach (@row)
  $rowResults[$counter].="$_\t" ;
 }

Does this get you out?
--Paul

 

[letsGo123]

paul -

it does, thanks. go get some pasta and a pint.