Limit to 3 in a specific section only & using RAND

Hi, degreesnorth.

This is what I usually do when I need to display different views of a list section the same page.

// load records from 'blog'
list($blogRecords, $blogMetaData) = getRecords(array(
        'tableName'   => 'blog',
        'loadUploads' => true,
        'allowSearch' => false,
));

// load records from 'blog'
list($blogRecordsRANDOM3, $blogMetaData) = getRecords(array(
        'tableName'   => 'blog',
        'limit'       => '3',
        'orderBy'     => 'RAND()',
        'loadUploads' => true,
        'allowSearch' => false,
));


<?php foreach ($blogRecords as $record): ?>
 shows all records in the order set in CMS
<?php endforeach ?>

<?php foreach ($blogRecordsRANDOM3 as $record): ?>
 shows 3 random records
<?php endforeach ?>

~ Deborah

Hi Deborah,

Your code is right. I tested it and I get the results that you are after.

All the records sorted by date and then three random records.

Can you attach your whole php page and include the URL to where you have this set up?
Or send the details into support@interactivetools.com.

Thanks!

Hi Deborah,

Whoops. I was reading the thread too quickly. Thought you had posted twice, issue and possible solution.

Thanks for sharing your code!

Hi Deborah

Thank you so much.  Works like a dream and one incredibly useful string of code.

Really appreciate your time to contribute back to me.

Thanks again.

Cheers

Carole