Filter by "where" not working

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

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

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

By gversion - November 29, 2011

Hi Robin,

Thanks for helping me out with that one!

Regards,
Greg