<?php if($dealer['num'] != 1 { continue; } ?> //  I will assign which record number I want to filter

I know I'm close but. ..

Thanks

Michael

The client has added another filter to the mix. They have asked that there be just a list of "agricultural" or "recreational" dealers.

I created a new separate list "dealer_types"(multiple check boxes) and associated it in the dealers section using the field name "type".

What I BELIEVE I need is a "if" {  continue;  } statement to filter only 1 type of dealer by the record number. Or an "if" "else" statement maybe..

                            <?php foreach ($canadian_statesRecords as $key=>$record): ?>
                                       <? // load records from 'dealers'
                                         list($dealersRecords, $dealersMetaData) = getRecords(array(
                                         'tableName'   => 'dealers',
                                         'loadUploads' => false,
                                         'allowSearch' => false,
                                         'where' => "providences LIKE '%\t". mysql_escape($record['num']) . "\t%'",
                                          ));
                                        ?>
                            <?php if(empty($dealersRecords)) { continue; } ?>
                                <section class="toggle<?php if ($key == 0) { echo " active"; } ?>">
                                    <label><?php echo htmlencode($record['title']) ?></label>
                                    <div class="toggle-content">
                                    <?php foreach ($dealersRecords as $dealer): ?>
                                    <?php IF DEALER "TYPE" NUM = ANYTHING BUT "1" { continue; } ?> //  I will assign which record number I want to filter
                                    <div class="panel-body">
                                      <strong><?php echo htmlencode($dealer['title']) ?></strong><br/>
                                             <p>
                                              <?php echo htmlencode($dealer['address']) ?><br/>
                                              <?php echo htmlencode($dealer['phone']) ?><br/>
                                              Contact: <?php echo htmlencode($dealer['contact_name']) ?>
                                             </p>
                                         <hr>
                                     </div>
                                     <?php endforeach ?>
                                    </div>
                                </section>
                            <?php endforeach ?>

Let me know what you think,

Thanks
Michael

Works awesome!

If the states are stored as a multiple choice, then it shows up in the database a little differently and thus the where clause needs to be changed. So try this instead:

<?php foreach ($statesRecords as $key=>$record): ?>
          <? // load records from 'distributors'
          list($distributorsRecords, $distributorsMetaData) = getRecords(array(
            'tableName'   => 'distributors',
            'loadUploads' => false,
            'allowSearch' => false,
            'where' => "states LIKE '%\t". mysql_escape($record['num']) . "\t%'",
             ));
           ?>
  <?php if(empty($distributorsRecords)) { continue; } ?>
  <div class="panel-group secundary" id="accordion2">
    <div class="panel panel-default">
      <div class="panel-heading">
       <h4 class="panel-title">
        <a class="accordion-toggle" data-toggle="collapse" data-parent="#accordion2" href="#collapse2<?php echo $key;?>"><?php echo htmlencode($record['title']) ?></a>
       </h4>
      </div>
      <div id="collapse2<?php echo $key;?>" class="accordion-body collapse">
          <?php foreach ($distributorsRecords as $distributor): ?>
            <div class="panel-body">
              <strong><?php echo htmlencode($distributor['title']) ?></strong><br/>
              <p><?php echo htmlencode($distributor['address']) ?><br/>
                 <?php echo htmlencode($distributor['phone']) ?><br/>
                 Contact: <?php echo htmlencode($distributor['contact_name']) ?>
              </p>
                                         <hr>
             </div>
          <?php endforeach ?>
                                   
        </div>
    </div>
  </div>
<?php endforeach ?>

This might need some tweaking to get it right though.

So there is the loop of States with a loop of distributors inside of it and then there will also be a loop of Providences with a loop of distributors right afterward. So you are only seeing the code for the first loop.

I was hoping to replicate the solution for the Providences once I had that. Just needed to get it working properly. 

Hope that helps 
Thanks

What's the 'states' field in the distributor table look like? Is it a list?

Any ideas?

There's a few different ways to do this depending on how efficient you want to be, but here's the simplest way:

<?php foreach ($statesRecords as $key=>$record): ?>
          <? // load records from 'distributors'
          list($distributorsRecords, $distributorsMetaData) = getRecords(array(
            'tableName'   => 'distributors',
            'loadUploads' => false,
            'allowSearch' => false,
            'where' => "states = '". $record['num'] . "'",
             ));
           ?>
  <?php if(empty($distributorsRecords)) { continue; } ?>
  <div class="panel-group secundary" id="accordion2">
    <div class="panel panel-default">
      <div class="panel-heading">
       <h4 class="panel-title">
        <a class="accordion-toggle" data-toggle="collapse" data-parent="#accordion2" href="#collapse2<?php echo $key;?>"><?php echo htmlencode($record['title']) ?></a>
       </h4>
      </div>
      <div id="collapse2<?php echo $key;?>" class="accordion-body collapse">
          <?php foreach ($distributorsRecords as $distributor): ?>
            <div class="panel-body">
              <strong><?php echo htmlencode($distributor['title']) ?></strong><br/>
              <p><?php echo htmlencode($distributor['address']) ?><br/>
                 <?php echo htmlencode($distributor['phone']) ?><br/>
                 Contact: <?php echo htmlencode($distributor['contact_name']) ?>
              </p>
                                         <hr>
             </div>
          <?php endforeach ?>
                                   
        </div>
    </div>
  </div>
<?php endforeach ?>

This checks the list of distributors and skips the state if no distributors are found.

  list($statesRecords, $statesMetaData) = getRecords(array(
    'tableName'   => 'states',
    'loadUploads' => false,
    'allowSearch' => false,
  ));


-------------------------------------------------------------




<?php foreach ($statesRecords as $key=>$record): ?>
  <div class="panel-group secundary" id="accordion2">
    <div class="panel panel-default">
      <div class="panel-heading">
       <h4 class="panel-title">
        <a class="accordion-toggle" data-toggle="collapse" data-parent="#accordion2" href="#collapse2<?php echo $key;?>"><?php echo htmlencode($record['title']) ?></a>
       </h4>
      </div>
      <div id="collapse2<?php echo $key;?>" class="accordion-body collapse">
          <? // load records from 'distributors'
          list($distributorsRecords, $distributorsMetaData) = getRecords(array(
            'tableName'   => 'distributors',
            'loadUploads' => false,
            'allowSearch' => false,
            'where' => "states = '". $record['num'] . "'",
             ));
           ?>
          <?php foreach ($distributorsRecords as $distributor): ?>
            <div class="panel-body">
              <strong><?php echo htmlencode($distributor['title']) ?></strong><br/>
              <p><?php echo htmlencode($distributor['address']) ?><br/>
                 <?php echo htmlencode($distributor['phone']) ?><br/>
                 Contact: <?php echo htmlencode($distributor['contact_name']) ?>
              </p>
                                         <hr>
             </div>
          <?php endforeach ?>
                                   
        </div>
    </div>
  </div>
<?php endforeach ?>

Can I write it somehow to list ONLY the states that actually have a distributor. Please Note: I built this as a list of states that are associated in a list of distributors. Maybe I need to move that get records to the outside of the loop?

Let me know what you think.