Originally posted by Frans C
Your code tries to insert 100 records with the same value, while the field only excepts unique values. I guess only the first insert statement succeeds.
No. It inserts about 20 of them. Problem not here. I'm talking about how to connect lot of querys to 1 line and only then send it to MySQL