I am editing the template for the email. I grabbed the mysql select statement from the results page (created with data assist and manipulated for my needs):
<?php
$ParamattendeeId_WADAattendee = "-1";
if (isset($_GET['attendeeId'])) {
$ParamattendeeId_WADAattendee = (get_magic_quotes_gpc()) ? $_GET['attendeeId'] : addslashes($_GET['attendeeId']);
}
$ParamSessionattendeeId_WADAattendee = "-1";
if (isset($_SESSION['WADA_Insert_attendee'])) {
$ParamSessionattendeeId_WADAattendee = (get_magic_quotes_gpc()) ? $_SESSION['WADA_Insert_attendee'] : addslashes($_SESSION['WADA_Insert_attendee']);
}
$ParamattendeeId2_WADAattendee = "-1";
if (isset($_GET['attendeeId'])) {
$ParamattendeeId2_WADAattendee = (get_magic_quotes_gpc()) ? $_GET['attendeeId'] : addslashes($_GET['attendeeId']);
}
mysql_select_db($database_ifpaDataBase, $ifpaDataBase);
$query_WADAattendee = sprintf("SELECT attendee.attendeeId, CONCAT_WS(' ',salutation, firstName, middleInitial, lastName) AS name , rankService, positionTitle, company, street, street2, city, stateCountry, postalCode, phoneNumber, faxNumber, email, payBy, paid, GROUP_CONCAT(sessionName SEPARATOR '; ') AS sessions FROM attendee LEFT JOIN attendeeSessions ON attendeeSessions.attendeeId = attendee.attendeeId LEFT JOIN sessions ON sessions.sessionId = attendeeSessions.sessionId WHERE attendee.attendeeId = %s OR ( -1= %s AND attendee.attendeeId= %s) GROUP BY attendee.attendeeId", GetSQLValueString($ParamattendeeId_WADAattendee, "int"),GetSQLValueString($ParamattendeeId2_WADAattendee, "int"),GetSQLValueString($ParamSessionattendeeId_WADAattendee, "int"), GetSQLValueString($ParamattendeeId_WADAattendee, "int"),GetSQLValueString($ParamattendeeId2_WADAattendee, "int"),GetSQLValueString($ParamSessionattendeeId_WADAattendee, "int"));
$WADAattendee = mysql_query($query_WADAattendee, $ifpaDataBase) or die(mysql_error());
$row_WADAattendee = mysql_fetch_assoc($WADAattendee);
$totalRows_WADAattendee = mysql_num_rows($WADAattendee);
?>
I did have some errors in the sql, but I fixed them and am still not getting an email
have I done something incorrectly with using this code? I'm connecting to the database fine, the information is being inserted into the database correctly. It's just not emailing.