Timer Problem

[Kuya Jeo 120]

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 120]

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 14]

22 minutes ago, Zhao Chow said:

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 120]

7 hours ago, Luffy said:

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 14]

52 minutes ago, Zhao Chow said:

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.