Sounds like a looping problem in your code. Can you supply the code around your INSERT statement so we can see what's going on? The only times I've experienced anything Roswell about MySQL is when I've written bad code. Rich > -----Original Message----- > From: Toby Parkins [mailto:toby@uknetweb.com] > Sent: Wednesday, November 13, 2002 1:42 PM > To: php-db@lists.php.net > Subject: Multiply Auto_Increments > > > Hi > > When ever I INSERT into a table with the values NULL into the ID > (AUTO_INCREMENT) field it adds in 1-4 extra blank records after. These > records have an AUTO_INCREMENT field which increases (+1) each time. > > Has anyone experienced this? > > Thanks, > > Toby Parkins > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php