Where Statement

3 posts by 2 authors in: Forums > CMS Builder
Last Post: August 7, 2012   (RSS)

By nmsinc - August 6, 2012

I have a problem with the 'where' statement below. When run it delivers all records when it should only deliver records where the field name wihin that section has been checked. Checked ="Yes" and unchecked ="No"

Any ideas anyone?

}
elseif ($CURRENT_USER['isAdmin']) {
$where = 'remove_record_from_listing = "Yes"';
}

Thanks - Ray
nmsinc

Re: [nmsinc] Where Statement

By gkornbluth - August 6, 2012

Hi Ray,

Have you tried a 1 (without the quotes) instead of a "yes"

$where = 'remove_record_from_listing = 1';

Just a guess.

Jerry Kornbluth
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php