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:
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
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:
Some reference: http://www.w3schools.com/sql/sql_and_or.asp
Hope that helps,
Robin
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
Programmer
interactivetools.com
Re: [robin] Filter by "where" not working
Hi Robin,
Thanks for helping me out with that one!
Regards,
Greg
Thanks for helping me out with that one!
Regards,
Greg