in reply to fetchrow_array DBI

I've tried it several ways as shown in the book ...

What book are you using?

If the book shows using do() to execute SELECT statements, then you need to get a new book. Consult the DBI documentation (via perldoc DBI) for an explanation.

You need to rework the code to look something like:

my $sth = $dbh->prepare(qq{SELECT ....}) or die "..."; $sth->execute() or die "..."; while ( my @row = $sth->fetchrow_array() ) { ... }