WHERE Command Usage?

5 posts by 2 authors in: Forums > CMS Builder
Last Post: February 6, 2009   (RSS)

By movierelics - February 5, 2009

I'm losing my mind here, but could you tell me what the usage for the WHERE command is to get it to display two records from the same table. I need to pull records that match the key words "Global" and "Alley". I've used the following variations with no luck.

'where' => 'department = "Alley" AND "Global"',

'where' => 'department = "Alley" AND
'department = "Global"',

'where => 'department = "Alley" && "Global"',

What is the correct format and is there any notes on the SQL format that you guys are using.

Re: [movierelics] WHERE Command Usage?

By movierelics - February 5, 2009

Also, when I use,

'where' => 'department = "Alley"' AND 'department = "Global"',

It displays articles tagged with other departments and not just the ones tagged "Alley" and "Global".

Re: [movierelics] WHERE Command Usage?

By Dave - February 5, 2009

Hi movierelics,

Is it a single value field or a multi value field? (eg: Is it a list field that lets you select multiple values at the same time?)
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] WHERE Command Usage?

By movierelics - February 5, 2009

Its the php sql code at the top of the page to get a news list to fill. Multiple stories from a single table.