Help with LOAD DATA LOCAL INFILE

[gamew0rld]

$sql2 = mysql_query("LOAD DATA LOCAL INFILE '/home/usr/public_html/dir/corp_list.csv' INTO TABLE corp_list OPTIONALLY ENCLOSED BY '"' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n'");

As soon as I as Optionally enclosed by '"' (which is ' " '), I get a Parse error. It works without it, but there are some fields which are enclosed in quotes, not all records are, though
Some lines look like this:

123456, "Description, More", 6, 4

others like this

234567, Description, 7, 5

Any idea what I can do?

[barand]

Try

$sql2 = mysql_query("LOAD DATA LOCAL INFILE '/home/usr/public_html/dir/corp_list.csv' INTO TABLE corp_list FIELDS OPTIONALLY ENCLOSED BY '"' TERMINATED BY ',' LINES TERMINATED BY '\r\n'");

Note repositioning of the word FIELDS

hth

[gamew0rld]

I still get a Parse error on that line

[barand]

Does the sequence matter when specifying fields terminated by etc ?
as in

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\' ]
]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]

[gamew0rld]

anyone have any ideas?

Could it be the the way each field is formatted in the mysql database?