SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Jun 2007
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question I need a script or code to send mass mail to many emails

    Hi,

    I have this MySQL command:

    Code:
    SELECT customers.cust_email
      FROM customers
    INNER
      JOIN cust_packages
        ON cust_packages.cpack_usernr = customers.cust_custnr
    GROUP
        BY customers.cust_email
    HAVING COUNT(cust_packages.cpack_usernr) = 
           COUNT(NULLIF(COALESCE(cpack_canceldate,'0000-00-00'),'0000-00-00'))
    For reference, please look the topic About a SELECT command to execute in my MysQL Database.

    Now, I need a script to send one message to all emails selected from the above command.

    Thanks.

  2. #2
    SitePoint Evangelist
    Join Date
    Aug 2005
    Location
    Winnipeg
    Posts
    498
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    phpList
    The only constant in software is change itself

  3. #3
    SitePoint Wizard PHPycho's Avatar
    Join Date
    Dec 2005
    Posts
    1,201
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Why don't you use PHPMailer?
    It's very easy to begin with.
    See PHPMailer usage Examples


Bookmarks

Posting Permissions

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