[thelist] How Would You Solve This? (Was: Um--Newsletter/Subscription Management)

[Mark Howells]

> Basically, client wants to sell subscriptions to her electronic newsletter.
> Customer can buy a six month subscription or a year subscription. How can
> client
> manage customerA, who signed up in January with a six month subscription,
> CustomerB who signed up in January with a year subscription, and CustomerC
> whose
> subscription has expired?

A database containing the subscriber info, including an "expires" date. The
mailing application would reference the subscriber database and only send
issues to the current subscribers (perhaps sending renewal notices to those
whose subscriptions had expired recently).

The exact solution would depend on the scale of the subscriber base and th
ebudget of the client, but a PHP / MySQL solution would be stable and fairly
easy to implement.

Regards
Mark Howells
<http://www.mark.ac/evl/>