PHP/MySQL help...

[whispers]

Hey gang-

having some trouble with my script...

everything 'seems' to be working fine (when I print out vars/data, it all is correct).. until I get to the part where I need to INSERT these multiple records into the database...

Odd thing is, I am not getting any errors at all.. to even help me troubleshoot.



goal/summary:
scrape a directory for as many .txt files as I find...
create array...

using this array I loop through all file names.. and open up the file.. strip out each line, explode into an array.. ($allLinesArray)


with my 'master' $allLinesArray.. I loop through it.. building a variable ($allRecords).. to be used in my MySQL INSERT command..

everythings seems to work.. everything echos/prints fine... but nothing gets dumped to the database..? no feedback? no errors? no warnings?

any suggestions? ideas?

thanks!




code:

function insertRecords(){
    
    global $allRecords, $myDB, $subDate, $allLinesArray, $result;
    //echo('INSERTING NEW RECORD<br><br>');
    //echo('TOTAL RECORDS: ' . count($paymentAmount) .'<br>');

    for($i=0; $i < count($allLinesArray); $i++) {
        
        
        if($i){
            $allRecords .= ',';
        }        
        
        //echo("CHECK: " . $allLinesArray[$i][142] . "<br>");
        //echo("CHECK: " . $allLinesArray[$i][2] . "<br>");
        //echo("looping: " . $i);
        
        //** first index is ID# (auto-populated)        
        $allRecords .= "('','$allLinesArray[$i][1]','$allLinesArray[$i][2]','$allLinesArray[$i][3]','','','$allLinesArray[$i][4]','$allLinesArray[$i][5]','$allLinesArray[$i][6]','$allLinesArray[$i][7]','$allLinesArray[$i][8]','$allLinesArray[$i][9]','$allLinesArray[$i][10]','$allLinesArray[$i][11]','$allLinesArray[$i][12]','$allLinesArray[$i][13]','$allLinesArray[$i][14]','$allLinesArray[$i][15]','$allLinesArray[$i][16]','$allLinesArray[$i][17]','$allLinesArray[$i][18]','$allLinesArray[$i][19]','$allLinesArray[$i][20]','$allLinesArray[$i][51]','$allLinesArray[$i][52]','$allLinesArray[$i][53]','$allLinesArray[$i][54]','$allLinesArray[$i][55]','$allLinesArray[$i][56]','$allLinesArray[$i][57]','$allLinesArray[$i][58]','$allLinesArray[$i][59]','$allLinesArray[$i][60]','$allLinesArray[$i][61]','$allLinesArray[$i][62]','$allLinesArray[$i][63]','$allLinesArray[$i][64]','$allLinesArray[$i][65]','$allLinesArray[$i][66]','$allLinesArray[$i][67]','$allLinesArray[$i][140]','$allLinesArray[$i][141]','$allLinesArray[$i][142]','$allLinesArray[$i][143]','$allLinesArray[$i][144]','$allLinesArray[$i][145]','$allLinesArray[$i][146]','$allLinesArray[$i][147]','$allLinesArray[$i][148]','$allLinesArray[$i][149]','$allLinesArray[$i][150]','$allLinesArray[$i][151]','$allLinesArray[$i][152]','$allLinesArray[$i][153]','$allLinesArray[$i][154]','$allLinesArray[$i][155]','$allLinesArray[$i][156]','$allLinesArray[$i][157]','$allLinesArray[$i][158]','$allLinesArray[$i][159]','$allLinesArray[$i][160]','$allLinesArray[$i][161]','$allLinesArray[$i][162]','$allLinesArray[$i][163]','$allLinesArray[$i][164]','$allLinesArray[$i][165]','$allLinesArray[$i][166]','$allLinesArray[$i][167]','$allLinesArray[$i][168]','$allLinesArray[$i][169]','$allLinesArray[$i][170]','$allLinesArray[$i][171]','$allLinesArray[$i][172]','$allLinesArray[$i][173]','$allLinesArray[$i][174]','$allLinesArray[$i][175]','$allLinesArray[$i][176]','$allLinesArray[$i][177]','$allLinesArray[$i][178]','$allLinesArray[$i][179]','$allLinesArray[$i][180]','$allLinesArray[$i][181]','$allLinesArray[$i][182]','$allLinesArray[$i][183]','$allLinesArray[$i][184]','$allLinesArray[$i][185]','$allLinesArray[$i][186]','$allLinesArray[$i][187]','$allLinesArray[$i][188]','$allLinesArray[$i][189]','$allLinesArray[$i][190]','$allLinesArray[$i][191]','$allLinesArray[$i][192]','$allLinesArray[$i][193]','$allLinesArray[$i][194]','$allLinesArray[$i][195]','$allLinesArray[$i][196]','$allLinesArray[$i][197]','$allLinesArray[$i][198]','$allLinesArray[$i][199]','$allLinesArray[$i][200]','$allLinesArray[$i][201]','$allLinesArray[$i][202]','$allLinesArray[$i][203]','$allLinesArray[$i][204]')";
        
        //echo($allRecords);
    }
        
        
        $insert = mysql_query("INSERT INTO placements(id, har_id, guar_num, last_name, first_name, middle_name, ss_num, dob,sex, marital_status, admin_date,admin_time, discharge_date, discharge_time, address_1, address_2, city, state, zip, ept_country, home_phone, work_phone, mobile_phone, employer, employer_address_1, employer_address_2, employer_city, employer_state, employer_zip, employer_country, employer_phone, acct_base_class, fin_class, total_charges, sbo_self_pay, sbo_bad_debt_bal, acct_bal, sbo_total_payments, sbo_total_adjustments, guarantor_last, guarantor_first, guarantor_ss_num, guarantor_dob, relationship, billing_address_1, billing_address_2, billing_city, billing_state,billing_zip, billing_country, billing_home_phone, billing_work_phone, ear_employer, ear_employer_address_1, ear_employer_address_2, ear_employer_city, ear_employer_stateear_employer_zip, ear_employer_country, ear_employer_phone, cvg_payor, claim_admission_type, claim_admission_source, claim_discharge_disposition,claim_occurence_code_1, har_occurence_code_1, claim_occurence_code_2, har_occurence_code_2, claim_occurence_code_3, har_occurence_code_3, claim_occurence_code_4, har_occurence_code_4, claim_condition_code_1, claim_condition_code_2, claim_value_code_1, har_value_code_amount_1, claim_value_code_2, har_value_code_amount_2, har_admission_diag, har_diag_code_1, har_diag_code_2, har_diag_code_3, har_diag_code_4, har_diag_code_5, har_diag_code_6, har_diag_code_7, har_diag_code_8, procedure_1, procedure_date_1, procedure_2, procedure_date_2, procedure_3, procedure_date_3, procedure_4, procedure_date_4, procedure_5, procedure_date_5, attending_physician_internal_num_1, attending_physician_internal_num_2, attending_physician_1, referring_provider_21, referring_provider_2, har_guar_id) VALUES" . $allRecords);
    
        $result = $insert;
        sendResults();    
}


function sendResults(){
    global $result;
    echo "<br>RESULT: " . $result;
    echo "RESULT: $result";
} 

when I print out the $allRecords var.. I get data like this:

('',Array[1],'Array[2]','Array[3]','','','Array[4]','Array[5]','Array[6]','Array[7]','Array[8]','Array[9]','Array[10]','Array[11]','

it seems to be putting the dataType or something?

but this prints out fine:
//echo("CHECK: " . $allLinesArray[$i][142] . "<br>");
//echo("CHECK: " . $allLinesArray[$i][2] . "<br>");


What am I doing wrong?