I am using a form to allow users to enter meeting requests which are then used by a telemarketing company to run campaigns to target customers at potential client companies to arrange meetings for the users sales team.
Each record is added to a MySQL database. When they save the form it creates the array of info to be added to the record and emails this to the user with their entries embedded into the body of the email
My problem is that the Autonumber field I am using in MySQL to id the meetings is not populated with anything. When the email is sent everything is displaying but where the ID should be it is blank. I have posted the code below for the generation of the email.
Can someone please help cause I am going crazy
Code: Select all
$email=$values["User_Email"];
$from=$values["User_Email"];
$cc="user@email.com.com";
$msg="";
$subject="Meeting Request ".$values["Operator"].", ".$values["Target1_Contact_Surname"].", Meeting ID ".$values["Meeting_ID"]; [color=#40FF40]//Meeting_ID is not displaying in the email[/color]
foreach($values as $field=>$value)
{
if(!IsBinaryType(GetFieldType($field)))
$msg.= $field." : ".$value."\r\n";
}
$ret=runner_mail(array('to' => $email, 'subject' => $subject, 'body' => $msg, 'from' => $from, 'cc' => $cc)); [color=#40FF40]//Meeting_ID is blank in here to but everything else that was entered in the form is fine.[/color]
if(!$ret["mailed"])
echo $ret["message"];
return true;Please needing your help.
Cheers