Pulling in first record from each category (set by list/radio buttons)

Hi,

Sure.  What you can do is use the getListOptions() function to loop though all your different show types, and then use getRecords to get a single record for each one.

In this example, we assume that you have a section called "shows", and that your radio button list is called "type"

<?php foreach (getListOptions("shows", "type") as $value => $label): ?>

  <?php
    list($showRecord, ) = getRecords(array(
      'tableName'    =>  'shows',
      'allowSearch'  =>  false,
      'limit'        =>  1,
      'where'        =>  "type = '".mysql_escape($value)."'",
    ));
    
    if (!$showRecord) { continue; } // skip if no record was found
    $show = $showRecord[0];
    
  ?>
  
  // output $show record here.


<?php endforeach ?>

Hope this helps get you started

Hi Hannah,

This code can be embedded in your HTML where you want the show records to be displayed.  Each iteration of the loop should output the HTML for a single one of your show "boxes".  If you would like us to step in and implement this for you, we can certainly do that.  If you could please email consulting@interactivetools.com we can go over some options.   As this looks like a pretty simple integration, I would expect the cost to be quite low.

Hope this helps