2. PHPRunner General questions
  3. Another email help?
This topic is locked

Another email help?

 		10/28/2009 5:53:39 PM
PHPRunner General questions
greggk author

Hello,

I'm sure my problem is pretty simple, but since I don't know much about php coding I thought I would post it on here and see if anyone can help.

I want to be able to send email to a user once their project reaches 100%. The status table has a "complete%" field, which is a drop down table. Once that field reaches 100% I would like the email to be sent out. The status table is linked to the project table, and the project table has the userid on it that has the email to be sent. I saw different examples of how to user the current user id to send email, but the user id that I want to send the email to is not even logged on, they are just the client user id that just need to be notified when their project is done. Is this too much of a hassle to do? Or is there a simple way of doing it?
J
 		Jane 10/29/2009

Hi,
you can select required information from another tables using this code as a sample:

global $dal;

$rstmp = $dat->TableName->Query("FieldName='".$values["FieldName"]."'","");

$datatmp = $db_fetch_array($rstmp);

$email = $datatmp["EmailField"];
greggk author 10/29/2009

Thank you so much, I'm going to try to see if I can get it to work <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=45015&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />



Hi,
you can select required information from another tables using this code as a sample:

global $dal;

$rstmp = $dat->TableName->Query("FieldName='".$values["FieldName"]."'","");

$datatmp = $db_fetch_array($rstmp);

$email = $datatmp["EmailField"];