$dbh->do("update Volunteer set volunteer_id = $new_id and Number = $newnumber where id = 2") or die $dbh->errstr;

##</code><code>##



  my $sth = $dbh->prepare("UPDATE Volunteer " .
      "SET Volunteer = ? " .
      "WHERE Date = ? AND Volunteer = 'TBD' AND Number = ?"
  ) or die $dbh->errstr;
  my $rv = $sth->execute($status, $date, $id) or die $dbh->errstr;