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
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
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
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [gkornbluth] Where Statement
By nmsinc - August 7, 2012
Thanks again Jerry - worked like a charm!
nmsinc