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