my $price = "50"; my $htmlvar = '
  • The price is \$$price
  • '; my $sth = $dbh->prepare(qq{UPDATE database SET htmlvar=? WHERE ID=?}); $sth->execute($htmlvar, $ID) or die $dbh->errstr; $sth->finish;