Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    2

    Unanswered: Database triggers an email???

    Hi,

    I am using asp+mysql to build a website.

    I want to send newsletters to people who subscribed at a time specified by them.

    Suppose I want my newsletters to come at 3:00am on 14th dec every year.

    the database has a table with
    Name
    Email
    date/Time

    Thanks,
    Vivian Aranha

  2. #2
    Join Date
    Apr 2006
    Location
    Denver, Co. USA
    Posts
    242
    Someone correct me if I am wrong, but mysql only responds to queries and has no way to execute anything on a scheduled basis.

    Normally, to accomplish what you want, you would write an ASP script to query the database and send out an email for those records that have a date/time in the past. Then you schedule your script to run, say every 5 minutes. Since you have ASP, I will assume you are on a windows operating system. The normal way to schedule a script to run on Windows is to use the task scheduler.

    Hope this helps...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •