471,045 Members | 1,299 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,045 software developers and data experts.

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


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

Nov 7 '06 #1
1 1242
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.

Nov 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Manuel Hegemann | last post: by
6 posts views Thread by Jeffrey Silverman | last post: by
4 posts views Thread by VB Programmer | last post: by
1 post views Thread by Lampa Dario | last post: by
2 posts views Thread by philb | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.