[mysql LOAD command]

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''electronics'' at line 1

[mysql LOAD command]

fixed spaces, still doesn't work. any other suggestions?

[mysql LOAD command]

i can't have spaces?

[mysql LOAD command]

I'm trying to build a script to load tab delimited text files into my database, but I can't get a working query. Here's what I got:

$command = mysql_query ("LOAD DATA LOCAL INFILE '/file.txt' INTO TABLE electronics FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (ITEM NUMBER, ITEM NAME, CATEGORY, SUB-CATEGORY, DESCRIPTION, WEIGHT, WHOLESALE PRICE, RETAIL PRICE, SHIPPING, HANDLING, CARRIER NAME, QUANTITY IN STOCK, IMAGE SMALL, IMAGE MEDIUM, IMAGE LARGE, DETAIL URL)");

if ($command) {

echo "<br>good";

} else {

echo "<br>bad";

}

It returns bad every time. Any suggestions? Thanks.