How do I add 3 days to a date

[kpetsche20]

I need to add 3 days to a date,

the date is in the format YYYY-MM-DD

 

public function start_date_plus_3($league)
{
$sql = mysql_query("SELECT * FROM pleagues WHERE id = '".$league."'") or die(mysql_error());
  while($data = mysql_fetch_array($sql))
  {
  $starttime = $data['startdate']
  $timestamp = strtotime($data['startdate']);
  }
}

[bluesoul]

I need to add 3 days to a date,

the date is in the format YYYY-MM-DD

 

public function start_date_plus_3($league)
{
$sql = mysql_query("SELECT * FROM pleagues WHERE id = '".$league."'") or die(mysql_error());
  while($data = mysql_fetch_array($sql))
  {
  $starttime = $data['startdate']
  $timestamp = strtotime($data['startdate']);
  $newtime = strtotime("+3 days",$starttime);
  }
}

[Mark Baker]

$newdate = strtotime('+3 days',strtotime('2008-12-29'));

 

[GingerRobot]

Better to do it all in the query:

 

$sql = mysql_query("SELECT *,UNIX_TIMESTAMP(startdate + INTERVAL 3 DAY) AS timestamp FROM pleagues WHERE id = '".$league."'") or die(mysql_error());

 

The timestamp would then be in $data['timestamp'];