Syntax frustration
I'm getting a syntax complaint with the following query
SELECT documents.DocPassportFirstName,
documents.DocPassportFamilyName,
countries.ConNationality,
documents.DocPassportNo,
documents.DocPassportIssueDate,
documents.DocPassportPlaceOfIssue,
documents.DocPassportExpiryDate,
documents.DocDLFirstName,
documents.DocDLFamalyName,
documents.DocDLNationality,
documents.DocDLNo,
documents.DocBdcWith,
documents.DocBdcPolNo,
documents.DocBdcTelNo,
documents.DocBdcExpiryDate,
documents.DocMOTDue,
documents.DocCCP,
documents.DocCCPPolNo,
documents.DocCCPTelNo,
documents.DocUpDate
FROM documents, countries
WHERE documents.DocPassportNationalty = countries.ConID
AND MemberID = $memberid;
MySQL Error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '' at line 1
I can't see what is wrong with it! Can anyone else see my mistake?
|