Hello guys,
i have a web application developed in php+SQL Server 2000. i need to import data from csv file into the database. i can do it using array. but the problem is the table structure and the sequence of the data in the csv file are not in same sequence. for example i have country of origin in the first row of the table but in the csv file it is in the 5th row. that is array[0] should be assign to 5th row and many of the data is in scattered way. can anyone tell me how to solve it.
best regards,
Mainul
i have a web application developed in php+SQL Server 2000. i need to import data from csv file into the database. i can do it using array. but the problem is the table structure and the sequence of the data in the csv file are not in same sequence. for example i have country of origin in the first row of the table but in the csv file it is in the 5th row. that is array[0] should be assign to 5th row and many of the data is in scattered way. can anyone tell me how to solve it.
best regards,
Mainul