Limit results based on check box option

2 posts by 2 authors in: Forums > CMS Builder
Last Post: November 9, 2012   (RSS)

By degreesnorth - November 8, 2012

Help, I'm stuck. I have a field called "applies to", for one of three centres - Brookvale, CP or Little Digs. I am trying to limit the list to only one of the centres, eg. Brookvale

eg. // load records
list($coming_up_eventsRecords, $coming_up_eventsMetaData) = getRecords(array(
'tableName' => 'coming_up_events',
'where' => ' applies_to="Brookvale" ',

));


However, that gives me no results. The code which is supplied from the code generator is this

<h1>Events / News - List Page Viewer</h1>
<?php foreach ($coming_up_eventsRecords as $record): ?>
Record Number: <?php echo $record['num'] ?><br/>
Event Name: <?php echo $record['title'] ?><br/>
Applies to: <?php echo join(', ', getListLabels('coming_up_events', 'applies_to', $record['applies_to'])); ?><br/>


but I have no idea how to only select Brookvale. Any ideas please?

Thanks