Combined listing pages into one page in date order

Hello,

This example should help get you started. Do your getRecords calls as you normally would, then do an array merge, then use this function with usort for date sort.

<?php

function cmp($a, $b){
    $ad = strtotime($a['date']);
    $bd = strtotime($b['date']);
    return ($bd-$ad);
}

$recordsMerged = array_merge($cinemaRecords, $liveRecords, $exhibitRecords); // merge arrays
usort($recordsMerged, 'cmp'); // sort articles by date

?>


<?php // output ?>
<?php foreach ($recordsMerged as $index => $record): ?>
  Record Info Here
<?php endif ?>


Cheers,
Steve

Thanks Steve, will give this a whirl during site build.

Hi Adrian,

On your new page that will combine and list from both sections, place the function in the top of your page. Then place each of your standard listing getRecords calls as you normally would.

<?php
  function cmp($a, $b){
    $ad = strtotime($a['date']);
    $bd = strtotime($b['date']);
    return ($bd-$ad);
  }

  // load your records from the "whats on" and "live events" tables
  // load records from 'yourtable_listings'
  list($yourtable_listingsRecords, $yourtable_listingsMetaData) = getRecords(array(
    'tableName'   => 'yourtable_listings',
    'loadUploads' => true,
    'allowSearch' => false,
  ));

  // load records from 'yourtable2_listings'
  list($yourtable2_listingsRecords, $yourtable2_listingsMetaData) = getRecords(array(
    'tableName'   => 'yourtable2_listings',
    'loadUploads' => true,
    'allowSearch' => false,
  ));

// merge the arrays returned from each getRecords call
$recordsMerged = array_merge($yourtable_listingsRecords, $yourtable2_listingsRecords); // merge arrays
usort($recordsMerged, 'cmp'); // sort articles by date
?>

Then in the body, place your foreach loop to display:

<?php foreach ($recordsMerged as $index => $record): ?>
  Record Info Here
<?php endif ?>

Hope this helps.

Cheers,
Steve

Great, glad it's working for you!

You can set "Order By" on both of those Section Editors in the CMS under the Sorting tab to date DESC. By default the CMS will sort your records by what is set in there. Best way to handle it.

The sorting can also be manipulated on the getRecords array:

'orderBy'  => 'set your sorting here',

Cheers,
Steve

Hi Steve ...

Updated the CMS to 'date DESC, title' but it's putting all events into backward order both on website and in the cms

i.e.. not the nearest date first

The main combined index page is still backward order too.

In the CMS when it was set to 'date, title' the events were all ordered listed correctly in the cms and on website pages (apart from the combined index page).

Hi Steve ...

Can I PM you?

My apologies, I read that too fast! Instead of DESC you'll want to use ASC, so it will be 'date ASC'. You should be good to go after that.

Cheers,
Steve

Thanks Steve ...

Will try this as soon as possible.

I've lost all access into an site cms pages or to the cms itself though. Getting the flooding error message from the cms:

The database error given was:
User update already has more than 'max_user_connections' active connections

Any ideas what this could be? Any one possibly messing around after I put the urls on the forum?