redcoder
asked on
read second row of csv file using php
Anyone know how to read a second row of a csv file using PHP?
I want to import only starting from second row onwards of the csv file into mysql.
I want to import only starting from second row onwards of the csv file into mysql.
ASKER
Is it possible to use those command with php? I tried with :
mysql_query("LOAD DATA INFILE 'vehicledata.csv' INTO TABLE 'vehicledatatemp' FIELDS TERMINATED BY ',' IGNORE 2 LINES ");
in php but it doesn't work
mysql_query("LOAD DATA INFILE 'vehicledata.csv' INTO TABLE 'vehicledatatemp' FIELDS TERMINATED BY ',' IGNORE 2 LINES ");
in php but it doesn't work
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
great. that really works.
you are great steelseth12..
:-)
you are great steelseth12..
:-)
Glad i could help.
Thank you for the points and the grade.
Thank you for the points and the grade.
For more info look at http://dev.mysql.com/doc/refman/5.0/en/load-data.html