here's my code:
<?
include("dbconnect.php");
$query = "LOAD DATA INFILE './poly.csv' INTO TABLE products FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' (item_id, item_sum, item_desc, item_unit, item_w, p_one, p_one_op)";
$result = mysql_query($query, $mysql_link);
?>
Is that correct.
Table is setup as:
id
item_id
item_sum
item_desc
item_unit
etc.
I want to enter the first fields in the comma file to the columns (or fields) that I have specified in the query.
file is located in the same directory that the script is being executed from.
doesn't seem to be working.
attached is the file.
I exported the file using excel and the save as feature.
