while(my $ref = $sth->fetchrow_hashref() ){
    ## do something with $ref
}

##</code><code>##

while(my %hash = $sth->fetchrow_hash() ){
    ## do something with %hash
}