function import_sheet($csv, $table, $pass, $boolscrub)
{
    global $flash, $error_flash, $dump;
    $count = 2;
    //first row is just colum names, so data rows start @ 2
    $column_names = innie(scrub_names(fgetcsv($csv)));
    //first row contains the column names instead of data
    backup_and_drop($table);
    while ($row = fgetcsv($csv)) {
        if (count($column_names) != count($row)) {
            $error_flash .= 'ERROR row length issue, row #' . $count . ', Check row for commas / syntax errors:';
            $fips = get_fips($row[$column_names['fips_code']]);
            $dump .= '<br/><div class="error"> ' . "<b>ROW #{$count}: " . $row[$column_names['state']] . " - state# " . $fips['state'] . ', county# ' . $fips['county'] . ', Div# ' . $fips['division'] . "</b><br/>";
            $dump .= "-> row has " . count($row) . " columns, CSV header has " . count($column_names) . " column names";
            $dump .= "</div><br/><br/>";
            continue;
        }
        $row = marry($column_names, $row);
        $fips = get_fips($row['fips_code']);
        $row = filter_columns($row, $pass);
        //rename fips to designate their parsing
        $row['state_fips'] = $fips['state'];
        $row['county_fips'] = $fips['county'];
        $row['division_fips'] = $fips['division'];
        if ($row['state_fips'] == 0 && $row['county_fips'] == 0) {
            $dump .= $count - 2 . " - skipped, now has no fips<br/>";
            $count += 1;
            continue;
        }
        $row = scrub_booleans($row, $boolscrub);
        if ($row['county_fips'] == 0) {
            $dump .= "<br/><b>" . strtoupper($row['county']) . " STATE " . " row inserted</b><br/>";
        } else {
            $dump .= $row['county'] . " county" . ($row['division'] ? ", " . $row['division'] . " division" : '') . " row inserted";
            $dump .= "<br/>";
        }
        $result = mysql_insert_array($table, $row);
        if ($result['mysql_error']) {
            $error_flash .= 'MYSQL: ' . $result['mysql_error'];
        }
        $count++;
    }
    if ($count == 2) {
        $error_flash .= 'no rows imported - does CSV have correct newline line endings?';
    } else {
        $flash .= "Successfully imported " . ($count - 2) . " offical rows";
    }
}
<?php

$boolscrub = array('pbvs', 'dre_pushbutton', 'dre_touchscreen', 'dre_dial', 'vvpat', 'dre', 'dre_x_vvpat', 'bmd', 'tbad', 'punchcard', 'hcpb', 'vote_by_mail', 'pp_acc', 'pp_std', 'pp_std_pc', 'pp_std_cc', 'ev_std', 'ev_acc', 'abs_ballots', 'prov_ballots', 'pp_acc_systems');
$pass = explode(' ', 'year state county division jurisdiction_type corrected_fips state_fips city_fips division_fips pbvs dre_vvpat dre_x_vvpat dre_pushbutton dre_touchscreen dre_dial vvpat dre bmd tbad punchcard hcpb vote_by_mail equip_type vendor make model firmware_version software_version quantity pp_std pp_std_pc pp_std_cc pp_acc pp_dis pp_dis_pc pp_dis_cc ev_std ev_acc abs_ballots prov_ballots pp_acc_systems');
$csv = $fref;
$count = 2;
//first row is just colum names, so data rows start @ 2
$column_names = innie(scrub_names(fgetcsv($csv)));
//first row contains the column names instead of data
backup_and_drop($table);
$dump .= "starting import<br/>";
while ($row = fgetcsv($csv)) {
    if (count($column_names) != count($row)) {
        $error_flash .= '<b>ERROR row length issue, row #' . $count . ', Check row for commas / syntax errors:</b>';
        $fips = get_fips($row[$column_names['fips_code']]);
        $error_flash .= '<br/>' . " State " . $row[$column_names['state']] . "  FIPS State " . $fips['state'] . ' - county ' . $fips['county'] . ' - Div ' . $fips['division'] . "<br/>";
        $error_flash .= "row has " . count($row) . " columns, CSV header has " . count($column_names) . " column names";
        $error_flash .= "<br/>";
        // print_r($row);
        break;
    }
    $row = marry($column_names, $row);
    $fips = get_fips($row['fips_code']);
    $row = filter_columns($row, $pass);
    $row['state_fips'] = $fips['state'];
    $row['county_fips'] = $fips['county'];
    $row['division_fips'] = $fips['division'];
    //find an official that has the same fips as this machine, linking official's id here as foriegn key
    $subquery = "SELECT id FROM official WHERE state_fips LIKE " . $fips['state'] . " AND county_fips LIKE " . $fips['county'];
    $result = mysql_query($subquery);
    $result = mysql_fetch_assoc($result);