http://qs321.pair.com?node_id=11106362


in reply to Re^2: Global symbol "$prepare" requires explicit package name
in thread Global symbol "$prepare" requires explicit package name

In addition to what poj said, instead of
$sth2 = $dbh->prepare("update $what$ever");
to see what's going on, write
my $sqltext = "update $what$ever"; print qq(SQL query is: "$sqltext"); $sth2 = $dbh->prepare($sqltext);
Perhaps there's a stray question mark in your $date_new