#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    2
    Rep Power
    0
    Hi everyone,

    I would like to send an email to 2 email adress or more when a value of specifics database fields have changed.

    It will be like an 'alert mail' ...
    Goal is to alert concerned user they've something to validate on the site


    ------------------
    Best regards,
    LDHA
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15

    I would like to send an email to 2 email adress or more when a value of specifics database fields have changed.


    if you want to send more than one email address using mail() function,then you can use space between the email addresses in the "To" field...

    eg:

    <?php

    $to="shiju@post.com hello_shiju@usa.net";
    $subject="test message";
    $body="hi from Shiju";
    mail($to,$subject,$body);
    ?>

    I hope this will work for you...



    ------------------
    SR -
    webshiju.com

    "The fear of the LORD is the beginning of knowledge..."
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    2
    Rep Power
    0
    Thanks for your answer but
    my main problem is not around mail generating.

    I don't know how to :
    - have a permanent (every 20 mn approx.) scanning of the database without manual launching ?
    - make this scanning script (perl, php) ?
    - make it as a 'scheduler' ?

    I would like it scans mysql database
    and, if it detects a change (boolean flag), it generates a mail to 2 users or more

    Thanks a lot for the one who will help me.


    ------------------
    Best regards,
    LDHA
  6. #4
  7. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    read this question and answers...
    http://www.devshed.com/Talk/Forums/F...ML/000622.html

    ------------------
    SR -
    webshiju.com

    "The fear of the LORD is the beginning of knowledge..."
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    36
    Rep Power
    15
    If the data changes via a php script then just work in the mail function with the function that changes the data

Similar Threads

  1. best way to send email validation
    By njcallen in forum PHP Development
    Replies: 2
    Last Post: January 28th, 2004, 10:02 AM
  2. Need to send email after signup
    By timsharpe in forum PHP Development
    Replies: 2
    Last Post: January 24th, 2004, 03:30 PM
  3. form to email and database
    By densma in forum ASP Programming
    Replies: 4
    Last Post: January 23rd, 2004, 02:19 AM
  4. email form: send results to CSV attachment
    By dandcp in forum PHP Development
    Replies: 0
    Last Post: January 21st, 2004, 04:44 PM
  5. send email using form
    By jis in forum HTML Programming
    Replies: 4
    Last Post: January 16th, 2004, 12:23 PM

IMN logo majestic logo threadwatch logo seochat tools logo