my $new_name;
for my $name ($name1, $name2, $name3) {
 $new_name = $name;
 $sth->execute($name);
 $sth->fetch or last;
 $new_name = '';
}

print "New name: $new_name" if $new_name;