in reply to fetchall_arrayref DBI question ?
$sth->execute(); $sth->bind_columns(\my ($col1, $col2, $col3)); while ($sth->fetch()) { print "$col1 $col2 $col3\n"; } [download]