Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: Emails sent out from MSSQL database

Bottom of Page

1 to 3 of 3

  1.  
    • CommentAuthoredgar
    • CommentTimeOct 31st 2006
     
    Hi,

    Please help I'm so lost. I don't know if I should put this here or in PHP forum so please forgive me if it shouldn't be here. I have this help desk I'm coding in PHP using a MSSQL databse. I have a user, rep and admin setup. On the admin side you can add, delete or edit statuses, email messages, priorities, categories, and locations.

    My issue is with the editing of the email. I want to have about 10 preset email messages in the database. Based on what the user does - i.e. Submit a new problem - I want the appropriate message to be sent via email to the user.

    My dilemma is how would I put the information from the submitted form or database into the email that is sent out.

    So let's say for instance this is in the database:

    Thank you
    • CommentAuthormicah
    • CommentTimeOct 31st 2006
     
    My only guess is that you are making use of the PHP 'Mail' function.

    Your detail is a little confusing?

    Do you want, when a form is submitted, for that to then send an email, to your own web sites email addresses to that of your admin staff.

    And to have this email directed to a particular address, depending on what is in the form being submitted.
    • CommentAuthoredgar
    • CommentTimeOct 31st 2006
     
    First, thanks for responding. Ok. This is just hard to explain. I have right now 4 different email massages in my database. I would like to send out an email message automatically based on what the user does.

    So my thoughts were to include the variables from the form being submitted in the email messages that are located in the database. Pull the message out of the database and mail the message using PHPmail function in the processing script file.

    That doesn't work. The dilemma is to get the information from the form and put it in the email that's going to be sent out to the user.

1 to 3 of 3

  1.