Gossamer Forum
Home : General : Databases and SQL :

I'm blind!

Quote Reply
I'm blind!
Ok..I bet I'm either being really stupid here Tongue I'm getting a problem with the following SQL statement;

SELECT * FROM Advertisers WHERE CreditLeft >= 5, Advertiser = 'Andy'


The error is;

Unable to get advertiser info. Reason: You have an error in your SQL syntax near ' Advertiser = 'Andy'' at line 1

Can anyone see why I'm getting this error? I can't for the life of me see why its not working! (I hate these memory blocks Frown)

Thanks

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread I'm blind! Andy 8904 May 9, 2002, 11:41 AM
Post Re: [Andy.] I'm blind!
Paul 8418 May 9, 2002, 12:01 PM
Thread Re: [Andy.] I'm blind!
Wil 8435 May 10, 2002, 1:35 AM
Thread Re: [Wil] I'm blind!
Andy 8459 May 10, 2002, 2:33 AM
Post Re: [Andy.] I'm blind!
Wil 8384 May 10, 2002, 2:36 AM