Get articles from different tables (subcategories)

I found a way to do this, I don't know if that's the best possible way to do it, but it works for me :)

On my products table, I create a list field with 4 options (select). Those options are SUB1, SUB2, SUB3, and SUB4 (you can name it in any way, just be sure to use the same name on the IF Statement below.

Then on my detail page I use this code:

                        <h2>Products</h2>
                        <ul class='left_navigation'>
                         <?PHP if ($productsRecord['category'] == "SUB1"): ?>
                         <?php foreach ($subcategory1Records 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 ?>
                         <?PHP endif ?>

                         <?PHP if ($productsRecord['category'] == "SUB2"): ?>
                         <?php foreach ($subcategory2Records 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 ?>
                         <?PHP endif ?>

                         <?PHP if ($productsRecord['category'] == "SUB3"): ?>
                         <?php foreach ($subcategory3Records 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 ?>
                         <?PHP endif ?>

                         <?PHP if ($productsRecord['category'] == "SUB4"): ?>
                         <?php foreach ($subcategory4Records 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 ?>
                         <?PHP endif ?>
                        
                        </ul>


This worked fine for what I'm looking for. If anyone knows a better way to do this, it will be great if he can share it! :)

Jesus

Hi Jesus,

That solution would definitely work.  The only issue I can see is that on any given page, you would load at least 3 record sets that would never be used.  To help keep the code clean, what you can do is use an if statement to figure out which table you should be getting records from and only load a single record set.

NOTE:  In this example I'm assuming that your tables are called sub1, sub2, etc

if ($productsRecord['category'] == "SUB1") {
    $tableName = 'sub1';
  }
  elseif ($productsRecord['category'] == "SUB2") {
    $tableName = 'sub2';
  }
  elseif ($productsRecord['category'] == "SUB3") {
    $tableName = 'sub3';
  }
  else {
    $tableName = 'sub4';
  }
  
  list($subcategoryRecords, $subMetaData) = getRecords(array(
    'tableName'    =>  $tableName,
    'allowSearch'  =>  false,
  ));

This way, in your code you can always just output $subcategoryRecords without having to worry about which record set you need.

Hope this helps