I'm pretty new to php/mysql, and I'm getting the following error on the code
segment below:
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting
T_STRING or T_VARIABLE or T_NUM_STRING in
/home/hserco10/public_html/online-reg/CheckPresence.php on line 114
mysql_query("LOCK TABLES Registrants READ");
$thisquery = "SELECT * FROM Registrants
WHERE (firstname = $firstname) and (lastname = $lastname) and (email = $email)";
$result = mysql_query($thisquery)
or die (LooksLikeWeGoofed);
mysql_query("UNLOCK TABLES");
mysql_close($connection);
if (!result)
{
header("Location: ErrorNoAccess.php");
die();
}
$num_rows = mysql_num_rows($result);
if ($num_rows == 1)
{
$row = mysql_fetch_array($result);
$_SESSION['XRecordID'] = $row['RegistrantID']; // *** LINE 114 ***
header("Location: GetAccessCode.php");
}
Can anyone help?
Thanks.