baronerosso
New Member
from the time length \[code\]2010-01-09 21:04:06 **to** 2010-02-08 21:04:06\[/code\]how can I get date + time at each 30 day interval ?So I should get \[code\]2010-02-09 21:04:062010-03-09 21:04:062010-04-09 21:04:062010-05-08 21:04:06\[/code\]So everyday, a script will check today's date to see if it matches one of above. If there's a match update all rows added before today.\[code\]$point1 = "2010-02-09 21:04:06"if (date("Y-m-d h:m:s") >= $point1){mysql_query('UPDATE table SET status='checked' WHERE lastadded < $point1');}\[/code\]