View Single Post
  #2   IP: 112.87.30.158
Old 2015-04-19, 08:58 AM
Gasconade Gasconade is offline
初级会员
 
Join Date: 2005-11-10
Posts: 1
Gasconade 现在声名狼藉
Default

With PHP you can do something like:

Code:
if($mydate_from_db > $present_date){
    $mydate_from_db = strtotime($mydate_from_db, '+ 10 days');
} else {
    $mydate_from_db = strtotime($present_date, '+ 10 days');
}
Or you can do it with mysql like:
Code:
UPDATE yourtable SET mydate = IF(mydate = '0000-00-00 00:00:00', '2013-06-18 00:00:00', DATE_ADD(mydate, INTERVAL 10 DAY));
Reply With Quote