my $index = map { next unless $_ eq 'ACCOUNT#'; $_ } @{$sth->{NAME}};
##Now, my original code:
@array_c = map { $$_[$index] } @{$sth->fetchall_arrayref()};