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