LOAD DATA INFILE query

[The_Chancer]

OK - I have a load file query that works well, (gives me warning, yet everything is uploaded OK into the database but that is not really the issue)

What I was wanting to know is if it is possible to exclude the first line as it includes the table headers as the CSV file is taken from an EXCEL spreadsheet.

Using

$query=mysql_query("LOAD DATA INFILE '$upload' INTO TABLE $this FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\r\n'");

Oh - if anyone can shed any light on the warnings etc provided by mysql_info() in PHP 4.3.1 and if there is any way of finding these I would be grateful.

Cheers,

[The_Chancer]

How simple ??

Just look at this now...

$query=do_query("LOAD DATA INFILE '$upload' INTO TABLE $this FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES");