Re: Syntax frustration Jerry Gitomer wrote:
>> 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?
>>
> Two suggestions. First, try putting $memberid in quotes. Second, verify
> the spelling of each of your column names.
No - don't do that.
Numbers should not be enclosed in quotes. |