Filter by "where" not working

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

By gversion - November 28, 2011

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: [gversion] Filter by "where" not working

By robin - November 29, 2011

Hey Greg,

Only the last where statement will have effect. You can combine sql conditions with "AND". Something like this should work for you:

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

));

Some reference: http://www.w3schools.com/sql/sql_and_or.asp

Hope that helps,
Robin
Robin
Programmer
interactivetools.com