###setup my dropdown
my @employee;
while (@row = $sth->fetchrow_array) { # Used with arrays
        # handle null and undef's
        $last_name               = (defined $row[2]) ? $row[2] : '';
        push @employee, $last_name;
}


##</code><code>##

foreach (@employee) {
	print "<option value=$_>$_\n";
}

##</code><code>##

<option value=SS_NUMBER>FIRST_NAME LAST_NAME

##</code><code>##

my @employee;
while (@row = $sth->fetchrow_array) { # Used with arrays
        # handle null and undef's
        $SS_NUMERB           = (defined $row[0]) ? $row[0] : '';
        $first_name          = (defined $row[1]) ? $row[1] : '';
        $last_name           = (defined $row[2]) ? $row[2] : '';
        push @SS_NUMBER, $SS_NUMBER;
        push @employee_firstname, $first_name;
        push @employee_lastname, $last_name;
}

##</code><code>##

<option value=$SS_NUMBER>$employee_FIRSTNAME $employee_LAST_NAME