load data infile and choosing which colums to use

[ericsante]

I have the following table

CREATE TABLE tbltranslog (
TransLog_ID int(10) NOT NULL auto_increment,
SubID int(5) NOT NULL,
Date char(21) NOT NULL,
Amount varchar(9) NOT NULL,
TransType varchar(32) NOT NULL,
TransResult varchar(10) NOT NULL,
AuthCode varchar(15) NOT NULL,
PRIMARY KEY (TransLog_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

and my CSV file contains the following fields:

"Sub ID","Transaction Date/Time","Amount","Consumer Name","Account Name","Transaction Type","Transaction Result","Authorization Code","Routing Number","Account Number","Account Type Description","Credit Card Number","Credit Card Expiration Date","Recurring Description","Company Name","Billing Address1","Billing Address2","Billing City","Billing State","Billing Zip","Billing Country","Shipping Address1","Shipping Address2","Shipping City","Shipping State","Shipping Zip","Shipping Country","Phone","E-Mail","Memo","Drivers License Number","Social Security Number","IP Address","Merchant Referrer Information","Merchant Order Number","Order Number","Comments","Transaction History Key","Referring Transaction History Key","Merchant Order Type","User ID","Authnet Auth Response","Authnet Auth Definition"

As you can see the CSV has more data then I want to keep, so the question is how do I ignore the fields that I do not want.

[WDPEjoe]

Parse the line into an indexed array. Then you just need to figure out which values you need. This is roughly what I think (you may need to clean it up a little bit):

$query = "INSERT INTO tbltranslog VALUES ";
// while loop
$line = fgets($file_handle);
$data = explode(",", $line);
$query .= "(NULL,'".$data[0]."','".$data[1]."','".$data[2]."','".$data[5]."','".$data[6]."','".$data[7]."'),";
//end while
$query = substr($query, 0, -1);
mysqli_query($link, $query);

[ericsante]

Thx, I'll give it a shot.