Timer Problem

[Kuya Jeo]

I want to add +1 Day or +3 Days in this one.. gettimestr("%Y-%m-%d %H:%M:%S",21)

Can someone know how to add? Thank you guys

 

[Kuya Jeo]

Got a solution. thnx anyway

i use DATE_ADD(NOW(), INTERVAL 1 DAY)

instead of using gettimestr("%Y-%m-%d %H:%M:%S",21)

 

[Luffy]

i use DATE_ADD(NOW(), INTERVAL 1 DAY)

can you explain how it work? we just need to change the day? ex. DATE_ADD(NOW(), INTERVAL 1 DAY) for 1 day and DATE_ADD(NOW(), INTERVAL 3DAY) for 3 days?

 

[Kuya Jeo]

can you explain how it work? we just need to change the day? ex. DATE_ADD(NOW(), INTERVAL 1 DAY) for 1 day and DATE_ADD(NOW(), INTERVAL 3DAY) for 3 days?

I rather used MYSQL Lines because im putting it on the database

If you want to add +3 Days it should be like this DATE_ADD(NOW(), INTERVAL 3 DAY)

 

[Luffy]

I rather used MYSQL Lines because im putting it on the database

If you want to add +3 Days it should be like this DATE_ADD(NOW(), INTERVAL 3 DAY)

oh i get it, thanks. i cant seem to make it work. setting up an array for 1 , 3 , 7 days whenever the item call func a 3 day it will activate the 3 days.