View Single Post

  #1 (permalink)  
Old 01-31-2007
Dan
 
Posts: n/a
Default 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?

Reply With Quote