In the following code, I am trying to make the $email variable reflect the CandidateCCPlaced.EmailAddr AS EmailAddr1 field.
Right now, it's
$email=$datatmp["EmailAddr1"];
and a echo shows that the variable $email= has nothing in it.
Meanwhile,
$email=postvalue("value_EmailADDR_1");
works fine, but my client does not want the employer to enter an email address. It needs to be pulled from the andidateCCPlaced.EmailAddr AS EmailAddr1 field.
How would I re-write $email=$datatmp["EmailAddr1"]; to make it work properly.
This is CRITICAL and I need it yesterday.
Thank you.
Mike
Here is the code:
if ($_REQUEST["a"]=="added")
{
$msg = "";
$rstmp = CustomQuery($_SESSION["sql"]);
//insert individual fields below
$msg.="<html>";
$msg.="<body text=\"#000000\" style=\"background-color:#ffffff; text-align:center; height:1000px;\"><div style=\"background-color:transparent;text-align:left;margin-left:auto;margin-right:auto;position:relative;width:750px;height:1000px;\">";
$msg.="<table cellspacing=\"0\" cellpadding=\"0\" style=\" border-collapse: collapse; position:absolute; left:177px; top:45px; width:448px; height:422px;\">";
$msg.="<tr>";
while ($datatmp = db_fetch_array($rstmp))
{
//start body email text:
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">There is a job offer for you from www.campstaffusa.com</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".""."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">First Name:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["FirstName"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Last Name:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["SurName"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Address:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["MailAddr"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">City:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["City"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">State/Province:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["Province"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Country:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["Country"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Candidate Email:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["EmailAddr1"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Primary Telephone #:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["PrimTele"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Job Title:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["JobTitle"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Job Description:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["JobDesc"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Begin Date:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["BeginDate"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">End Date:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["EndDate"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Summer Work Address:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["WordAddr"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Employer Email Address:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["EmailADDR"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Supervisor:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["SupName"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Supervisor Telephone #:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["SupTele"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Supervisor Email Address:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["SupEmail"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Transportation Description:</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".$datatmp["TransDesc"]."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">If, for any reason, you feel you cannot accept this position, please email us at hired@campstaffusa.com and contact your recruiter with details.</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".""."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Please note: Start and End dates reflect actual work dates. You are expected to arrive one day prior to the Start Date and expected to leave one day after the End Date.</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".""."</span></p></td></tr>";
$msg.="<tr><td style=\"width:50%; height:8%; vertical-align:top; padding:1px 4px 1px 4px; background-color:#ffff99;\"><p class=\"Normal-P\"><span class=\"Normal-C\">Contact your recruiter with any questions.</span></p></td><td style=\"width:50%; height:8%; vertical-align:top;
padding:1px 4px 1px 4px; background-color:#e9f5f8;\"><p class=\"Normal-P\"><span class=\"Normal-C\">".""."</span></p></td></tr>";
//end body email text
$msg.="</tr>";
$msg.="
";
}
$msg.="</table>";
$msg.="</div>";
$msg.="</body>";
$msg.="</html>";
//end individual fields
$email=$datatmp["EmailAddr1"];
//$email=postvalue("value_EmailADDR_1");
$subject=postvalue("value_subject_custom_1");
$from=postvalue("value_from_custom_1");
echo $email;
echo $subject;
echo $from;
//to add HTML tags, uncomment the following line and put html in
$ret=runner_mail(array('to' => $email, 'subject' => $subject, 'htmlbody' => $msg, 'from'=>$from, 'charset' => 'UTF-8'));
//$ret=runner_mail(array('to' => $email, 'subject' => $subject, 'body' => $msg, 'from'=>$from));
if(!$ret["mailed"])
echo $ret["message"]."
";
$_SESSION["sql"] = "";
echo "<p><a href='javascript:window.close();'>Close window</a></p>";
exit();
}
else
{
$sql = "SELECT
Employer.EmailADDR,
Employer.CompName AS subject_custom,
Employer.CompName AS from_custom,
Employer.WordAddr,
Employer.SupName,
Employer.SupTele,
Employer.SupEmail,
Employer.TransDesc,
CandidateCCPlaced.FirstName,
CandidateCCPlaced.SurName,
CandidateCCPlaced.EmailAddr AS EmailAddr1,
CandidateCCPlaced.PrimTele,
CandidateCCPlaced.MailAddr,
CandidateCCPlaced.City,
CandidateCCPlaced.Province,
CandidateCCPlaced.Country,
CandidateCCPlaced.JobTitle,
CandidateCCPlaced.JobDesc,
CandidateCCPlaced.BeginDate,
CandidateCCPlaced.EndDate,
CandidateCCPlaced.CandidateCCID,
Employer.EmployerID
FROM Employer
INNER JOIN CandidateCCPlaced ON Employer.EmployerID = CandidateCCPlaced.holdby
where CandidateCCID in (";
for ($i=0;$i<count($_REQUEST["selection"]);$i++ )
$sql.=$_REQUEST["selection"][$i].",";
$sql = substr($sql,0,-1);
$sql.=")";
$_SESSION["sql"] = $sql;
}