use DBI; . . . my $sql = 'INSERT INTO ' . $table . '(title, description, filename, path) VALUES (?, ?, ?)'; my $sth = $dbh->prepare($sql); while ($some_condition) { $sth->execute( $title, $description, $filename, $storagePath ); # do stuff which modifies condition and perhaps # the insertion values }