PDA

View Full Version : importing CSV


Blade_runner
11-27-2006, 08:21 AM
Hi

I am having problems importing data in to my table, i keep getting the same error Parse error: syntax error, unexpected T_STRING on line 64

here is my code
LOAD DATA INFILE 'csv/data2.csv' INTO TABLE company
FIELDS TERMINATED BY ','
(company_name,comment,phone,fax,num_of_emp,website,physical_add);

thank u to anybody that can help.:thumbsup: t

guelphdad
11-27-2006, 03:13 PM
well your error is a result of a missing ' or " so can you show us the entire code including your PHP code? use [ php] and [/php] (minus the space in the first tag) so that your code highlights correctly.

Blade_runner
11-28-2006, 12:30 PM
well your error is a result of a missing ' or " so can you show us the entire code including your PHP code? use [ php] and [/php] (minus the space in the first tag) so that your code highlights correctly.

Thank you, i managed to seat and work on it and eventually i got it, thanks again