> Ok. There are 2103 rows like this in my csv file. I've (now) confirmed that > 5 times. Yet when I run the above script, it will sporadically skip large > amounts of rows?! In one particular case it will go from "429" skips to > "519" and "1444" skips to "1638," when there are in fact normal rows just > like this. Feel free to look at the csv file and see if you see anything > wrong: > > http://www.azuritedesign2.com/One-Fourth/test.csv > > These are the INSERT commands generated by the above script: > > http://www.azuritedesign2.com/One-Fourth/importdata.php > > It all looks like it should work right? Then why am I missing 395 rows of > data? in different places? Only 1708 get inserted. > > Is there a bug in MySQL? Make sure that when you generate the insert queries, you double-up any single quotes in the field values. (Line 215, for example, has one.) -- Sarah Sweeney Portfolio http://sarah.designshift.com Blog http://hardedge.ca