Show States if a record exists

Hi Michael

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.

OK I think my 'where' statement must be wrong. If I comment the 'where' statement out, I get the list of ALL possible distributors in each state. When I set the line back then I get NO states showing at all. So it must no be sorting the records correctly.

Any ideas?

Hi Michael

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

It is one of two lists that is used inside the distributors list (see attached)

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

Okay, what kind of list is it? A dropdown? A multiselect? Checkboxes?

In this case I used a pull down multiple choice list. But I usually use check boxes.  Are there separate ways to express both?

Do you need anything else from me?

Hi Michael, sorry for the delay on this.

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.