array_groupBy and display image https://interactivetools.com/forum/forum-posts.php?array_groupBy-and-display-image-82320 Sun, 14 Jun 2026 09:09:24 -0700 en-us array_groupBy and display image https://interactivetools.com/forum/forum-posts.php?postNum=2245029#post2245029 What if you created a $researchRecords loop first and then loop over other items? It might be easier if you submitted a support request so I can see how everything is being joined together and I can more specifically help with a code snippet.

https://www.interactivetools.com/support/request/

]]> Wed, 23 Sep 2020 07:06:32 -0700 forum-posts.php?postNum=2245029#post2245029 array_groupBy and display image https://interactivetools.com/forum/forum-posts.php?postNum=2245016#post2245016 Thanks Carl - however that's not working.

I kind of think that this is because the code you've supplied is to display the image per research record - whereas I'm trying to get the image associated to each "brand" based on the grouping

$researchSeries = array_groupBy($researchRecords, 'brandsNum:label', true);

Thoughts?

]]> Fri, 18 Sep 2020 15:52:03 -0700 forum-posts.php?postNum=2245016#post2245016 array_groupBy and display image https://interactivetools.com/forum/forum-posts.php?postNum=2245015#post2245015 Hi Toledoh,
Were you only wanting to display a single image? In your getRecords function, you are including the uploads in your results so the following code should do the trick you're wanting. Note: I haven't tested it, so you might need to change some things to get it to work. If you want to display multiple images, you can just loop the $image variable and get every image attached to the record.

<?php foreach($researchSeries as $series => $items): ?>
	<div class="row">
	<div class="col">

	<?php
	$image = $items['images'];
if (!empty($images[0]['urlPath'])):
	?>
	<img src="<?php echo $images[0]['urlPath']; ?>">
    <?php
endif;
	?>

    <h3><?php echo htmlencode($series) ?></h3></div>

    </div>
       <?php foreach ($items as $record): ?>.....<?php endforeach ?>
    <?php endforeach ?>
]]> Fri, 18 Sep 2020 11:59:15 -0700 forum-posts.php?postNum=2245015#post2245015 array_groupBy and display image https://interactivetools.com/forum/forum-posts.php?postNum=2245014#post2245014 Hi All.

I'm grouping records by brand with the code below:

// load records from 'independent_research_reports'
list($researchRecords, $researchMetaData) = getRecords(array(
'tableName' => 'independent_research_reports',
'where' => "`typeNum` = '1'",
'loadUploads' => true,
'allowSearch' => false,
));
$researchSeries = array_groupBy($researchRecords, 'brandsNum:label', true);

Sor to display the brand, I use;

<?php foreach($researchSeries as $series => $items): ?>
<div class="row">
<div class="col"><h3><?php echo htmlencode($series) ?></h3></div>
</div>
   <?php foreach ($items as $record): ?>.....<?php endforeach ?>
<?php endforeach ?>

My question is, how do I go about displaying an image with each brand?

<?php foreach($researchSeries as $series => $items): ?>
<div class="row">
<div class="col">

[IMAGE HERE]
<h3><?php echo htmlencode($series) ?></h3></div>

</div>
   <?php foreach ($items as $record): ?>.....<?php endforeach ?>
<?php endforeach ?>

]]> Thu, 17 Sep 2020 04:05:05 -0700 forum-posts.php?postNum=2245014#post2245014