The fetchrow_array just gets you a single row. You can use it in a while loop to get all the rows one by one:

while (my @fields=$sth->fetchrow_array) {
   Do_Stuff(\@fields);
}
[download]

Or you can get the whole lot into an array reference in one gulp with

my $fields = $sth->fetchall_arrayref;
[download]

§ George Sherston