MySQL in a Nutshell

Name

fetchrow_array( )

Synopsis

$statement_handle->fetchrow_array( )

This returns one row from the results of a statement handle in the form of an array, each of whose element is a column.

...
my $sql_stmnt = "SELECT title, author FROM books";
my $sth = $dbh->prepare($sql_stmnt);
$sth->execute( );
while (my ($title, $author) = $sth->fetchrow_array( ){
   print "$title by $author \n";
}
$sth->finish( );