I know the code I'm using is primitive but what am I missing here?

1) you're not using placeholders, and you're probably not using quote( see http://bobby-tables.com/ )

2) and you're preparing way too much (prepare once outside of loop, then ->execute($addr); inside loop )

The situation you describe is hard to believe, so you're better off using Data::Dump::dd for debugging instead of print