Filter by "where" not working

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

Hello,

I am trying to load my listing records using the following code:

list($listingRecords, $listingDetails) = getRecords(array(
'tableName' => 'listings',
'where' => "status <> '1'",
'where' => "listing_type = '1'",
'ignoreHidden' => 'true',

));


I only want to display records with a status of 0 or 3, however the "where" code I am using to define the "status" doesn't make any difference. All records are being displayed no matter what their status.

Is there something I am missing or doing wrong, perhaps because I am trying to use two "where" statements?

Thanks for any help you can offer.

Regards,
Greg

Re: [robin] Filter by "where" not working

Hi Robin,

Thanks for helping me out with that one!

Regards,
Greg