Include additional table

Hi dlsweb,

Can you please tell me how to also include in the random display Features in my Vendor table with a top_photo.

Can you just duplicate the code, eg: 

// load records for featured vendors
list($vendorsRecordsFEATURED, $vendorsMetaData) = getRecords(array(
'tableName' => 'vendors',
'where' => ' featured LIKE "1" ', // if checkbox for featured is checked
'limit' => '5', 
'orderBy' => 'RAND()', 
'loadUploads' => true,
'allowSearch' => false,
));

<?php foreach ($vendorsRecordsFEATURED as $record): ?>
<?php if ($record['top_photo']) : ?>
<?php foreach ($record['top_photo'] as $index => $upload): ?>
<p><a href="<?php echo $record['_link'] ?>">
<img src="<?php echo htmlencode($upload['thumbUrlPath']) ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" />
<br />
<?php echo htmlencode($record['title']) ?>
</p>
<?php endforeach ?>
<?php endif; ?>
<?php endforeach ?>

Would that work for you? 

I wasn't clear

I would like features from my festival table 
and
features from my vendors table to both be in the roattion

Hi dlsweb, 

Could you combine both arrays into one?  Do both sections have the same fields? 

// combine two recordsets into one
$featuredRecords = array_merge($festivalsRecordsFEATURED, $vendorsRecordsFEATURED);
...
<?php foreach ($featuredRecords as $record): ?>


Or if the seconds are the same, maybe add a field called "Type" that can be of value: festival or vendor.

Got it, thanks so much