in reply to fetchrow_hashref Confusion

By de-referencing: 
my %hash = %{$sth->fetchrow_hashref()};

[download]
But you don't have to do that ... you could do something like: 
while (my $row = $sth->fetchrow_hashref()) {
   my $mail = $row->{mail};
   print "$mail\n";
}

[download]
just as easily IMHO.

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

In Section Seekers of Perl Wisdom