Adding a day to a date

[psmshankar]

Hi..
how to add a given number of say to a date value??
i have to discard the data in my table which are 3/4 or
whatever days(specified in table) older that posted date...
lets say posted date is 2002-11-05 and another column contains the max days is 5
so 2002-11-05 + 5 days = 2002-11-10
this is what i need to get??? how 2 do it in PHP?
is there any function??

[jburfield]

$date = "2002-11-05";
$next = 5;

$date_array = explode("-", $date);
$year = $date_array[0];
$month = $date_array[1];
$day = $date_array[2];

$newdate = date("Y-m-d", mktime(0,0,0,$day + $next, $month, $year);

print($newdate);

This will print "2002-11-10"

That's just one way to do it...off the top of my head.

If you are using MySQL you can also look at the 'date_add' functions inside of MySQL, they are quite useful.

-- Jason

[buck2bcr]

Here is a way too, I'm sure there are a few. Instead of exploding it uses timestamps.

$date = "2002-11-05";  // put your date into a variable
$date_stamp = strtotime($date); // convert date to timestamp
$add = 60 * 60 * 24 * 5; // add number of seconds in 5 days
$add_stamp = $date_stamp + $add; // add to timestamp
$new_date = date("Y-m-d", $add_stamp); // format to new date
echo"Original Date = $date<br>New Date = $new_date"; // test results

HTH

[psmshankar]

thank u guys....