I know support has been discontinued, but maybe another user has an idea on how to help me??
I am using the Send Mail to Recipients from Record Set, with MX Send Email version 3.6.5 (PHP/MySql).
Program is located at: http://www.masonicpathways.com/testcontact.php.
After submitting the form, two things are not happening...
1. The email is not getting sent
2. The redirect should go to contact_us_autorespond.html, but it goes to testcontact.php? - which does nothing.
Here is the code:
<?php require_once('Connections/connform.php'); ?>
<?php
// Load the common classes
require_once('includes/common/KT_common.php');
// Load the tNG classes
require_once('includes/tng/tNG.inc.php');
// Make a transaction dispatcher instance
$tNGs = new tNG_dispatcher("");
// Make unified connection variable
$conn_c KT_connection($connform, $database_connform);
// Start trigger
$formValidation = new tNG_FormValidation();
$formValidation->addField("name_con", true, "text", "", "1", "", "Please enter a valid Name.");
$formValidation->addField("email_con", true, "text", "email", "", "", "Please enter a valid E-mail Address");
$formValidation->addField("phone_con", false, "text", "phone", "", "", "Please enter a valid Phone Number");
$formValidation->addField("message_con", true, "text", "", "1", "", "Please enter a valid message.");
$tNGs->prepareValidation($formValidation);
// End trigger
//start Trigger_EmailRecordset trigger
//remove this line if you want to edit the code by hand
function Trigger_EmailRecordset(&$tNG) {
$rsemailObj = new tNG_EmailRecordset($tNG);
$rsemailObj->setRecordset("rsMail");
$rsemailObj->setFrom("{email_con}");
$rsemailObj->setTo("email_dep");
$rsemailObj->setSubject("Masonic Pathways Contact Submission from {name_con}");
//WriteContent method
$rsemailObj->setContent("<P>Masonic Pathways Contact Submission for {id_dep_con}</P>\n<P></P>\n\n<P>Name: {name_con}</P>\n<P>Email: {email_con}</P>\n<P>Phone: {phone_con}</P>\n<P>Address: {address_con}</P>\n<P>Preferred Contact Method: {preferred_con}</P>\n<P></P>\n<P>Feedback/Message: {message_con}</P>\n");
$rsemailObj->setEncoding("ISO-8859-1");
$rsemailObj->setFormat("HTML/Text");
$rsemailObj->setImportance("Normal");
return $rsemailObj->Execute();
}
//end Trigger_EmailRecordset trigger
//In order for the rsDepartment recordset to only contain UNIQUE departments:
//First seven (7) records in the department_dep table must be:
//Masonic Village Estates, Michigan Masonic Home, Sanders Health Care Center, Rehab Center, Doig Chapel/Conference Center, Volunteer Opportunities, and Employment Opportunities
//If add any more departments then add as record number 8, 9, 10 etc. this will take some manipulating of the id_dep field, AND change the
//query statment below to include the total number of unique departments.
mysql_select_db($database_connform, $connform);
$query_rsDepartment = "SELECT * FROM department_dep WHERE id_dep <= 7 ORDER BY id_dep ASC";
$rsDepartment = mysql_query($query_rsDepartment, $connform) or die(mysql_error());
$row_rsDepartment = mysql_fetch_assoc($rsDepartment);
$totalRows_rsDepartment = mysql_num_rows($rsDepartment);
$colname_rsMail = "-1";
if (isset($HTTP_POST_VARS['name_dep'])) {
$colname_rsMail = (get_magic_quotes_gpc()) ? $
