Adding with dates in PHP

[dprichard]

I have a variable that I am trying to add one day to and return in the same format.  I don't know if I need to convert it first, but it is not working the way I am trying to do it.

 

while ($req_dates <= $req_end) {

mysql_query("INSERT INTO test_request(req_dates, req_ident, req_emp, req_status, req_type, req_on_date) VALUES('$req_dates', '$req_ident', '$req_emp', '$req_status', '$req_type', '$req_on_date')") or die(mysql_error());

$req_dates = new DateTime($req_dates);
$req_dates->modify("+1 day");
$req_dates->format("Y-m-d");

 

I have a while loop and I need to add one day and return the variable again. 

 

Any help would be appreciated.

[dprichard]

the variable contains the date formated like this 2007-12-21