Where Statement Issue

3 posts by 2 authors in: Forums > CMS Builder
Last Post: October 2, 2011   (RSS)

Re: [MickC] Where Statement Issue

By Dave - October 2, 2011

Hi MickC,

Try this:
'where' => ' (sales_status="In Stock" OR sales_status="Coming In") and approved="1" ',

I removed some extra single quotes and added brackets to make the logic more explicit.

Let me know if that works for you.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Where Statement Issue

By MickC - October 2, 2011

Top Job Dave,

That was it!

I can see now why it wasn't working correctly

Thanks mate