Need a script to send an online course in 20 lessons / newsletter

[Sebastian Spandauer]

Hey,

i am searching for a php script that features sending a lets say 20
lesson online course.
it should:

subscription on website
opt-in after subsriciption
send one lesson per day to every subscriber
first lesson on the day of subscription
easy unsusubscribe on website
comfortable managing the list / statstic

I searched for scripts and only found newsletter-scripts
where every user get the same (and not "his" lesson !!!)
every day or whatever.

Any ideas?
Thank you for your help
Sebastian

[frothpoker]

Assuming you have a database....

build a table for subsribers holding their personal information,
including registration date.

build a table for courses course details

build a table for lessons with a key of courseID/lesson#

Build a cross reference table between subscribers and their courses

you then need a script that does the following:-

find first subsriber - gives you the email address:
find first cross reference record for the subscriber - gives you
the course ID
work out number of days since subsription - gives you the
lesson ID.
fire off an email to the email address for the lesson
find next cross reference record for the subsriber and repeat
indented section
find next subsriber and repeat indented section

This is pretty simple simple using While or For-Next loops but really
depends on your database structure.