PHP - MySQL Date Calculation Support
I am developing a site that sells subscriptions, which offer options such as 3-month, 6-month, 1-year subscriptions. The orders_table has a column for a TIMESTAMP to capture the date the subscription was purchased. There is also a column for subscription-end date.
There is another table that hold the subscription options and has a column for number of days. The user will choose from a drop-down list from this table, the subscription they want to purchase; i.e. - 6 month subscription. The row in the table for this record has 180 in the number-of-days column. Therefore, when the order gets inserted into the orders_table, I need to not only store the current TIMESTAMP, but also add the number_of_days column to the current date, in this example 180 days, to the TIMESTAMP and store that also as the end date for the subscription.
Willing to pay for this extension. I need it very fast.
Thanks in advance
Comments
Be the first to write a comment
You must me logged in to write a comment.