Ok, I have a .csv file. the first key in the array is the name of the tables. the rest of the info is the data that needs to be put into my mysql database. Here is an example of what my array looks like. Array ( [0] => Array ( [0] => RECORD_TYPE [1] => BORROWER_FIRST_NAME [2] => BORROWER_MIDDLE_NAME [3] => BORROWER_LAST_NAME [4] => BORROWER_SUFFIX_NAME [5] => BORROWER_COMPANY_NAME [6] => LENDER [7] => LENDER_ADDRESS [8] => LENDER_CITY [9] => LENDER_STATE [10] => LENDER_ZIP [11] => LENDER_PHONE_NO [12] => TRUSTEE [13] => TRUSTEE_ADDRESS [14] => TRUSTEE_CITY [15] => TRUSTEE_STATE [16] => TRUSTEE_ZIP [17] => TRUSTEE_PHONE_NO [18] => PROPERTY_DESCRIPTION [19] => CASE_NO [20] => LOAN_NO [21] => LOAN_DOC_NO [22] => FORECLOSURE_DOC_NO [23] => FORECLOSURE_BOOK [24] => FORECLOSURE_PAGE [25] => PARCEL_ID_NO [26] => TRUSTEE_SALE_NUMBER [27] => SITUS_ADDRESS [28] => SITUS_UNIT_NO [29] => SITUS_CITY [30] => SITUS_COUNTY [31] => SITUS_STATE [32] => SITUS_ZIP [33] => APPRAISED_VALUE [34] => MINIMUM_BID [35] => JUDGMENT_AMOUNT [36] => LOAN_AMOUNT [37] => LOAN_BALANCE [38] => DATE_OF_LOAN [39] => INT_RATE [40] => PAYMENT [41] => MATURITY [42] => AUCTION_DATE [43] => AUCTION_TIME [44] => AUCTION_ADDRESS [45] => AUCTION_CITY [46] => LEGAL_DESCRIPTION [47] => RECORDING_DATE ) [1] => Array ( [0] => T [1] => KATHLEEN [2] => [3] => PHILLIPS [4] => [5] => [6] => NATIONSTAR MORTGAGE, LLC [7] => JUST LAW, INC [8] => [9] => [10] => [11] => [12] => [13] => [14] => [15] => [16] => [17] => [18] => COMM [19] => [20] => [21] => [22] => [23] => [24] => [25] => S1134120670 [26] => [27] => 11101 W. AMITY RD [28] => [29] => BOISE [30] => BOISE [31] => ID [32] => 83709 [33] => [34] => [35] => [36] => [37] => $91,325.12 [38] => [39] => 7.88% [40] => [41] => [42] => 9/10/2010 [43] => 11:00 AM [44] => 9465 W. EMERALD ST., STE. 260 [45] => BOISE [46] => COMMENCING AT THE NORTH QUARTER CORNER OF SECTION 34, TOWNSHIP 3 NORTH, RANGE 1 EAST [47] => 5/10/2010 ) [2] => Array ( [0] => T [1] => ARNEL [2] => T [3] => BERMUDO [4] => [5] => [6] => NATIONSTAR MORTGAGE LLC [7] => JUST LAW, INC [8] => [9] => [10] => [11] => [12] => [13] => [14] => [15] => [16] => [17] => [18] => RSFR [19] => [20] => [21] => [22] => [23] => [24] => [25] => [26] => [27] => 5718 N. MILLDAM PL [28] => [29] => GARDEN CITY [30] => BOISE [31] => ID [32] => 83714 [33] => [34] => [35] => [36] => [37] => $109,781.84 [38] => [39] => 6.88% [40] => [41] => [42] => 9/3/2010 [43] => 11:00 AM [44] => 9465 W. EMERALD ST., STE. 260 [45] => BOISE [46] => LOT 12 IN BLOCK 3 OF MILLSTREAM NO. 1 SUBDIVISION, ACCORDING TO THE PLAT THEREOF [47] => 5/10/2010 ) Here is the code that I am trying. Obviously its not working properly. $tablenames = $data2DArray[0]; unset($data2DArray[0]); $i=0; foreach ($tablenames as $tablename){ foreach($data2DArray as $datakey => $data){ echo "{$tablename}={$data[$i]}<br>"; } $i++; } -------------------------------------- Basically I need this to turn into a usable mysql insert query. Need to be able to insert into mysql_table set RECORD_TYPE='T', BORROWER_FIRST_NAME='KATHLEEN' etc
$cols = $yourArray[0]; $colCnt = count($cols); $tablename = 'sometable'; // data is yourArray starting at index 1 for ($x=1; $x<count($data); $x++) { // start query again $qry = 'insert into ' .$tablename .' '; for ($i=0; $i< count($cols); $i++){ // append qry with key and values $qry .= $cols[$i] ." = '".$data[$x][$i]."', <br>" .chr(10); } // chop off last comma $qry = substr($qry, 0, -1); } // output will look like this /* insert into sometable RECORD_TYPE = 'T', BORROWER_FIRST_NAME = 'KATHLEEN', BORROWER_MIDDLE_NAME = ' ', BORROWER_LAST_NAME = 'PHILLIPS', LENDER = 'NATIONSTAR MORTGAGE, LLC'... insert into sometable RECORD_TYPE = 'T', BORROWER_FIRST_NAME = 'ARNEL', BORROWER_MIDDLE_NAME = 'T', BORROWER_LAST_NAME = 'BERMUDO', LENDER = ' MORTGAGE LLC'... */