cancel / renew membership

[aspbeginner]

I am trying to design the cancel/renew membership.asp page. Have you worked with it before? Please share it with me. I am trying to think of a way for it. Is there a way to include an expiration date when their membership has ended? I have included in the database a field with a timestamp. If the customer places a one month order, how will the site cut them off unless they renew their membership? I am confused
on this one.


More Information:
--------------------------------------------------
I am using session variables. I did design a login page that requires the user to be logged in. I did design a registration page that requires the user to fill the information out with the hidden stamptime field (that stores login time/date to the database). If the customer wants to renew a membership, it redirects to the renewmembership page. If the customer wants to cancel a membership, contact the customer service department via e-mail.

Suppose, the customer wants to renew a membership in the renewmembership page, it has two buttons:

"Click here to purchase 1 month at $10.00"
"Click here to purchase 3 months at $25.00"

If the customer clicks on the first button, it takes to the authorize.net site (transaction online for verifying credit card) that shows the order information, credit card information and customer billing information.

Have you worked with this kind of project before? I have not worked with it before. If you have worked with cancel/renew membership project before, is there another way to do it other than what I have told you? Please share ideas with me.

My question is how to include an expiration date into the database (I need to add expiration date field). If their membership has ended, how do I delete that customer? I want to inform the customer a week before their membership expiration.. how do I do it?

 

[hithere]

While I haven't done this type specifically you might want to consider a couple of options.

1. Try to stay away from session variables

2. Have you considered using cookies? You could set a "security level" that only works as long as the membership is active (set the cookie to expire the same time the membership ends). Once it expires, customer would be redirected to the renew membership page at their next login (via redirect).

3. Set a field in your database so that again, from the cookie, the user has visibility of only certain links. The cookie would reveal which links would be on or off. This would be dependent on how your db is built.

Hope that gives you some insight.
Mark