Two WHERE clauses

2 posts by 2 authors in: Forums > CMS Builder
Last Post: March 9, 2009   (RSS)

By zip222 - March 9, 2009

Can someone tell me the proper format for using two where clauses.

This is what I am using now:

'where' => 'display=1',
'where' => 'archive=0',

I want to list the records that match both of those clauses.

thanks,
jason

Re: [jdancisin] Two WHERE clauses

By Dave - March 9, 2009

Hi Jason,

Try this:
'where' => ' display=1 AND archive=0 ',

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com