Add days to date

drax007

Hello

Any ideas on how can add a variable number of days (retrieved from database) to a date (also retrieved from database) to give a new date and then output the new date value????

e.g. Both queries i have already retrieve and output the number of days and the SowDate.

84 2009-07-01

<?php echo $row_newtest['LifeTime'];?>
  <?php echo $row_test['SowDate']; ?>

I just need to add the days to the sowdate to give my new date...(which later is inserted a db.)

Any help would be be ace!

Thanks 🙂

NogDog

You can use [man]strtotime/man using "+3 days" (for example) for the format string argument. Or, it might be easier to just do it as part of the database query, doing the "date arithmetic" using the DBMS's date functions, such as MySQL's DATE_ADD() function.

drax007

Thanks for the reply....

sounds good, but im just not sure how to integrate the DATE ADD with the php query variables, any ideas please? 🙂

Thanks

NogDog

Let's suppose you want a date 1 week after some date value in the database:

$sql = "SELECT *, DATE_ADD(`date_col` INTERVAL 1 WEEK) AS `next_week` FROM `table` WHERE `id` = $id";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
echo "One week later: " . $row['next_week'];