while($hash_ref = $sth->fetchrow_hashref){ #dereference my %values=%$hash_ref; #print out usernames print $values{'username'};} #### $testUsername