while(my $rr = $sth->fetchrow_hashref()) {
    print "$_: $rr->{$_}\n" for keys %$rr;
}

##</code><code>##

while(my @rows = $sth->fetchrow_array()) {
    print "Values: @rows\n";
}

##</code><code>##

while(my @rows = $sth->fetchrow_array()) {
    print "$_: $rows\n" for @rows;
}