Hello,
I've a table using a list field (checkboxes multiple value), where the user can select from up to 6 options the product category each product uses. On my detail page, where I need to show just the products I need on a menu, I'm using this:
// load records from 'ssbr'
list($ssbrRecords, $ssbrMetaData) = getRecords(array(
'tableName' => 'ssbr',
'where' => "application = 'Polymer Modification' ",
'orderBy' => '', // use default database order
'loadUploads' => true,
'allowSearch' => false,
));
and where I need to show the menu this code:
<section id="side_navi-4" class="widget_side_navi">
<h2>SSBR Products</h2>
<ul class='left_navigation'>
<?php foreach ($ssbrRecords as $record): ?>
<li class="page_item page-item-54"><a href="<?php echo $record['_link'] ?>"><?php echo htmlencode($record['title']) ?></a><div></div></li>
<?php endforeach ?>
</ul>
</section>
But no product it has been displayed yet... am I missing something?
I must say that on my ssbr products table each product can have multiple values from the application list values, that's why I choose a checkbox list.
Thanks for pointing me out for the right direction here.
Jesus