argh forget that. simply put the id auto_increment field *last* in the create table defn, leave everything else as it was. On Thu, Jul 26, 2012 at 10:38 PM, tamouse mailing lists <tamouse.lists@xxxxxxxxx> wrote: > With one change to the data file to make the indexing work correctly > and read all the fields: to accommodate the first id auto_increment > field, the first value in the csv line must be null: > > null.a,b,c,d,e > null,f,g,h,i,j > null,k,l,m,n,o > > And further, the field count should subsequently be one less in line > 53 when creating the table: > > for ($i=0; $i < (count($fields)-1); $i++) { > > and that should do it. > > On Thu, Jul 26, 2012 at 10:20 PM, tamouse mailing lists > <tamouse.lists@xxxxxxxxx> wrote: >> Brad, do take a look at http://pastie.org/4340383 >> It does work. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php