Adding days to a date value and inserting the new value into a date field

Hi All,

I’m trying to use one date value in a form to insert 2 date values into a new record. The date fields are called event_end_date and removeDate.

If an event_end_date is entered in the form, on submission I want to:
A)  enter that date in the event_end_date field
B)  add 7 days to that date and enter the new date into the removeDate field

*** I can’t figure out how Accomplish step “B”

Thanks for your help,

Jerry Kornbluth
 
Here’s the code I’m using so far.

Near the top of the page to define variables:

 $event_end_date = date("Y-m-d",mktime(0,0,0,@$_REQUEST['month_2'],@$_REQUEST['day_2'],@$_REQUEST['year_2']));  //Works to populate the event_end_date field

And, I’ve tried both:

$end_date_plus_7_days =date("Y-m-d", strtotime($event_end_date . " +7 day");
and
$end_date_plus_7_days = strtotime(date("Y-m-d", strtotime($event_end_date)) . " +7 day");

but neither work to populate the removeDate field

In my mysql insert I’m using:

event_end_date    = '".mysql_escape($event_end_date)."',
and
removeDate     = '".mysql_escape($end_date_plus_7_days)."',

And in the form I'm using:

<tr>
              <td class="body-text-bold-9">Event End Date</td>
              <td> Month:
                <select name="month_2">
                  <?php foreach(range(1,12) as $month_2): ?>
                  <option value="<?php echo $month_2;?>"><?php echo date("F",strtotime("0000-$month_2"));?></option>
                  <?php endforeach ?>
                </select>
                Day:
                <select name="day_2">
                  <?php foreach(range(1,31)as $day_2): ?>
                  <option value="<?php echo $day_2;?>"><?php echo $day_2;?></option>
                  <?php endforeach ?>
                </select>
                Year:
                <select name="year_2">
                  <?php foreach (range($lowestYear,$highestYear) as $year_2):?>
                  <option value="<?php echo $year_2;?>"><?php echo $year_2;?></option>
                  <?php endforeach?>
                </select></td>
            </tr>