Ok..I bet I'm either being really stupid here 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 )

Thanks

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Umm mysql isn't going to know what bool to use unless you change that comma ;)

Andy

Shouldn't that be?


- wil

Yeah, got it working now. You don't need the () parts though. This was working for me;

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

Thanks for the reply though

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Hi Andy

You don't need the parenthesis, no. But in my experience, it doesn't hurt to put them in to clarify your syntax for the sake of readability, especially if you're executing a complex query.

- wil