View Single Post

   
  #7 (permalink)  
Old 02-28-2008, 10:04 AM
Sanders Kaufman
 
Posts: n/a
Default 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.
Reply With Quote