I retract my previous hasty red-herring comment. Hassan is right about the number of columns. Wes At 08:03 AM 8/6/2004, you wrote: >Rob Smith wrote: > >>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? > >No. The format of the INSERT command you're using requires a value >*for each column of the table*. > >>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 there's an obvious clue -- entry 429 has 6 fields, 430 has only >5. Too bad PHP apparently doesn't bother to pass back error messages >(or stop entirely on error) or you'd have discovered this as soon as >you hit item 35. :-) > >HTH! > >P.S. you can use LOAD DATA INFILE to bypass this issue entirely... >-- >Hassan Schroeder ----------------------------- hassan at webtuitive.com >Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com > > dream. code. > > >-- >* * Please support the community that supports you. * * >http://evolt.org/help_support_evolt/ > >For unsubscribe and other options, including the Tip Harvester and >archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !