display of additional category content with headings

Hi Deborah

You can't really do this with getListOptions if you need more than the title from the service categories section. What you'll need to do is load the categories records, as you're doing below, then sort them by the value (not the label) being used in the services section to associate each service with a category.

So ideally what you'll want to end up with is an array of categories where you can get the relevant category info by selecting it like so:

$categoriesArray[$service['category']]

Then all you'll need to do is echo the title and description from this as needed.

Does that make sense?

Hi, Claire and thanks for the reply.

I completely understand and appreciate the "why" of your explanation, but my various attempts of implementation result in a tangle of errors. If you were to modify the code I provided, exactly what would that look like?

I should tell you that my PHP knowledge is based primarily from examples that I can copy and understand after the working code is in place. I then keep a library of code solutions to recycle for various CMSB projects.

If this is beyond standard forum assistance, Claire, please let me know.

And thanks again.
Deborah

Sorry Deborah, I've got this kinda backwards. I assumed you wanted to output services and then the categories associated with each, instead of the other way around.

Really the best way you can handle this is to get to grips with PHP arrays. Setting up an array with specific, relevant keys is pretty much the solution to everything when you're working with two lists of records.

So let's start from the beginning. Here's how it'd work:

// categories for headings
    list($services_categoriesRecords, $services_categoriesMetaData) = getRecords(array(
    'tableName'   => 'services_categories',
    'allowSearch' => false,
  ));

 // list of services to display beneath headings
    list($servicesRecords, $servicesMetaData) = getRecords(array(
    'tableName'   => 'services',
  ));

You have two arrays to play with here - $services_categoriesRecords and $servicesRecords. You already know that the categories are the main grouping, and that each category should have its own list of services, so the categories are going to come first when you start looping through each array. What you need after that is a way to group the services by their category, and have each group be accessible when you're outputting the category information.

First thing to do is create what's called a multidimensional array - an array of arrays. Here's how it'd look:

$serviceGroups = array(); // create the new multidimensional array, so it's ready for use

foreach ($serviceRecords as $record) { // start looping through the services
    $serviceGroups[$record['category']][] = $record; // make magic happen
}

The bolded line above is the important one. What it does is:

• Adds a category num as a new key to $serviceGroups.
• Creates a new array and assigns it to that key.
• Adds a service record to this new array.

That's basically all the sorting you need, and it's done automatically. The serviceGroups array now consists of a super-array filled with a bunch of little arrays, each of which has a bunch of service records in it. And you can access any of the little arrays using the category num and the usual square bracket array notation.

$arrayOfServices = $serviceGroups[$correctCategoryNum]; // this is just to show you the notation, don't include it in your code

That's everything in the head. Now here's the output:

<?php foreach ($services_categoriesRecords as $record) : ?>
    <?php if(!isset($serviceGroups[$record['num'])) continue; ?> // skip empty categories if no array of services exists for them
   
    <?php echo $record['title']; ?>
    <?php echo $record['description']; ?>
   
    <?php foreach ($serviceGroups[$record['num']] as $service) : ?>
        <?php echo htmlencode($service['title']) ?>
    <?php endforeach; ?>
<?php endforeach; ?>

And that's it. I highly recommend reading up on how to use PHP arrays - http://php.net/manual/en/language.types.array.php. Once you understand arrays, you can do just about anything in PHP.

Claire, I can't thank you enough for taking the time to prepare that explanation and example. I can now see how powerful arrays can be and will try to gain a better understanding of the principles of using them.

Thanks again, Interactive Tools for your expert assistance!

~ Deborah