importing a csv into the db

[eluser]ray73864[/eluser]
basically what you want to do is tell the 'load data infile' what each field in the csv file matches up with in the database table.

your example using numbers makes this rather complicated to visualise, but it should work, what you do is try it out and then fine tune it to make sure your information ends up where it should do in the database table.

my previous example above should show how to do it properly.