This is my query in some script
query_sql "UPDATE go_premium SET `expiration_date` = DATE_ADD(NOW(), INTERVAL 7 DAY) WHERE `account_id` = "+ getcharid(3) +"";
it works fine for me but my question is how can i change the "DATE_ADD(NOW(), INTERVAL 7 DAY" to the value of the expiration date table + 7 days can someone teach me some tricks?
Question
Kudo
i have some question guys!..
This is my query in some script
query_sql "UPDATE go_premium SET `expiration_date` = DATE_ADD(NOW(), INTERVAL 7 DAY) WHERE `account_id` = "+ getcharid(3) +"";
it works fine for me but my question is how can i change the "DATE_ADD(NOW(), INTERVAL 7 DAY" to the value of the expiration date table + 7 days can someone teach me some tricks?
Link to comment
Share on other sites
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.