in reply to Why does DBI prepare break my loop?
In addition to the remarks of the others, you may want to read up on placeholders and bind values to reduce the amount of preparing of statements.