my $sql = "select max(Number) from Volunteer where Date =? and Volunteer = 'TBD'";
   my $number = $dbh->selectcol_arrayref($sql, undef, $date);

   my $id = "Date = '$date' and Volunteer = 'TBD' and Number = $number";
   my $content = "Volunteer";
   my $status = "$name";
   my $sth=$dbh->prepare('UPDATE Volunteer set Volunteer =?, WHERE =?');
   my $rv=$sth->execute($status, $id);

        print $query->h1({-align=>'center'}, "You signed up for this date $date");
$sth->finish ();
$dbh->disconnect ();