problem w/ mysql_query...

[admoore]

I am trying to automate the importing of data comma-delimited data into a MySQL database. Somthing is wrong with my query and I can't quite get my finger on the problem. I suspect a syntax error but don't see it.

TIA for any help...

-A

$result = mysql_query("LOAD DATA LOCAL INFILE '/lc_import/fixed_list.txt'
                       INTO TABLE `lost_calls`
                       FIELDS TERMINATED BY ',' ENCLOSED BY '\"'
                       ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
                       (`dealer_code`, `firstname`, `lastname`, `address`, `city`,
                        `state`, `zip`, `home`, `work`, `email`, `vin`, `year`, `make`,
                        `model`, `advisor_id`, `advisor_name`, `lost_date`)",$linkid);

 

[KarveR]

Can't say I've ever tried LOAD DATA from a php page before now.
And as a mysql question, probably more pertinent for the mysql forum.
What errors does your page return ?

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[sleipnir214]

You can issue a LOAD DATA INFILE query from PHP. YOU cannot, however, issue a LOAD DATA LOCAL INFILE.

The "LOCAL" keyword tells MySQL that you will be transmitting the datafile through the connection from the client, not from a file on the filesystem. See

http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html

Want the best answers? Ask the best questions!

TANSTAAFL!!