Posted by frothpoker on 11/07/06 17:07

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.

[Back to original message]