foreach $alright ($open_them) { my $sth = $dbh->prepare(qq{ insert into webcrawler (url_to,url_from,next_date,date_added) values ('$alright','$domain',CURDATE(), CURDATE() ) }); $sth->execute(); $sth->finish(); }