Loading csv file data to MySQL table

[mhoward]

I am trying to use a PHP script to upload data from my csv file to my table.

The command I have is...

$data = "LOAD DATA INFILE $file_loc INTO TABLE $tblname IGNORE 1 LINES";

Can anyone tell me if this command is correct?

Also, how can I specify that the fields within the file are seperated by commas(,) and are no enclosed by anything?

[Anon]

You will want it look like this.

$query=mysql_query("LOAD DATA LOCAL INFILE \"/path/to/file/data.csv\" REPLACE INTO table $tblname FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n\r'")or die("Error Executing the Query");

[mhoward]

OK - I tried that with
$query=mysql_query("LOAD DATA LOCAL INFILE \"$file_loc\" REPLACE INTO table $tblname FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n\r'")or die("Error Executing the Query");

But I just get the die message!