Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Sebastian Spandauer
November 7, 2006, 4:50 pm
rate this thread
i am searching for a php script that features sending a lets say 20
lesson online course.
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.
Thank you for your help
Re: Need a script to send an online course in 20 lessons / newsletter
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
fire off an email to the email address for the lesson
find next cross reference record for the subsriber and repeat
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.