Various inserts not actually inserted.

[mastasparkle]

I have this code that does a little loop (usually around 20-30 times) and inside the loop is about 6 lines of code. One of them is an insert into a MySQL database. Now sometimes the lines don't actually get inserted.

What could be going on? I am positive it's not a code problem. Could the rapid inserts be messing it up? If so, is there a way to add a buffer. Could it be something else?

[raymie]

without seeing the code is it hatd to say but....

I would suspec t that the inserts are sometimes failing either because of an SQL error due to specific field values or because of clashing primary keys etc...