Records from multiple sections into one viewer

Brilliant just what i needed, thanks Chris!

Hi Zick,

In your code, you are only getting the first 9, elements of the array, for 13, try this:

// after all records are merged, limit to 13 perPage
$mediaMergeRecords = array_slice($mediaMerge, 0, 13);

You can then loop through $mediaMergeRecords normally.

Hope this helps, please let us know if you run into any issues.

Jason, I tried to disable the //'perPage' in the load records for each record, but all the records load on one page. Is it possible to remove the 'perPage' from the load records for each record and apply the 'perPage' to the $mediaMergeRecords so there's only one 'perPage' that controls all the merged records?

// load records
list($galleryRecords, $galleryMetaData) = getRecords(array(
'tableName' => 'gallery',
//'perPage' => '7',
'orderBy' => 'createdDate DESC',
));

// load records
list($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
//'perPage' => '2',
'orderBy' => 'createdDate DESC',
));

// load records
list($_incoming_mailRecords, $_incoming_mailMetaData) = getRecords(array(
'tableName' => '_incoming_mail',
//'perPage' => '4',
'orderBy' => 'createdDate DESC',
));

foreach($_incoming_mailRecords as &$record) {
$record['title'] = $record['subject'];
$record['media_description'] = $record['text'];
//$record['media_description'] = $record['html'];
$record['media'] = $record['attachments'];
}
unset($record);

//////////////////////////// Load Multiple Records Array ///////////////////////
$mediaMerge = array();
$mediaMerge = array_merge($galleryRecords, $newsRecords, $_incoming_mailRecords);
// after all records are merged, limit to 13 perPage
$mediaMergeRecords = array_slice($mediaMerge, 0, 13);

Hi Zick,

In your code, you are only getting the first 9, elements of the array, for 13, try this:

// after all records are merged, limit to 13 perPage
$mediaMergeRecords = array_slice($mediaMerge, 0, 13);

You can then loop through $mediaMergeRecords normally.

Hope this helps, please let us know if you run into any issues.

Hi Zick,

I think you're on the right track. If you return all record for each section, then merge them into one array, you can implement a type of "perPage" by using a for loop to loop through a certain number of elements in the array.

Take a look at this post:
http://www.interactivetools.com/forum/gforum.cgi?post=88633#88633

This shows an example of creating pagination for a category list. You can use the same basic idea to control the number of records you output from your merged array.

Hope this helps