Ok, just tried on live, I must have messed something up....again! In my recordset I have WHERE tblcases.CaseID = "tblcases_CaseID2", now when I load my page I get the following error:
Parse error: syntax error, unexpected T_STRING in D:\Domains\ghldomain.co.uk\wwwroot\4\tblcases_Insert.php on line 135
Line 135 is:
$query_rsFilter4Email = "SELECT tblcases.ContactAssignedTo, tblcontacts.ContactEmail, tblcases.CaseID FROM tblcontacts Inner Join tblcases On tblcases.ContactAssignedTo = tblcontacts.ContactID WHERE tblcases.CaseID = "tblcases_CaseID2" ORDER BY tblcases.CaseID Desc ";
I replaced the "" with '' on where clause which allows page to load but no email is sent, I also change where clause to WHERE tblcases.CaseID = $_SESSION['tblcases_CaseID2'], but that also produces page error of : Parse error: syntax error, unexpected T_VARIABLE in C:\wamp\www\filter4.php on line 35
Am I writing the Where incorrectly?