Link to top record only but when on the same list page

Hi Hannah,

So, if I understand correctly, you have some side navigation, and one of the menu items links to the shows list page.  On the shows list page, however, you want the side bar link to go to the first show record, instead of the list page.  Is that right?  Can you show me the side navigation code you are using?

Thanks

Hi Jason,

That's right. For all other pages:

// load records from 'shows'
list($showsRecords, $showsMetaData) = getRecords(array(
'tableName' => 'shows',
'limit' => '1',
'loadUploads' => true,
'allowSearch' => false,
));

<?php foreach ($showsRecords as $record): ?>
<a class="read-more" href="<?php echo $record['_link'] ?>"> Read more >></a>

and then on the list page I need the top to pull in all so:

// load records from 'shows'
list($showsRecords, $showsMetaData) = getRecords(array(
'tableName' => 'shows',
'loadUploads' => true,
'allowSearch' => false,
));

<a href="<?php echo $record['_link'] ?>" class="side">View next upcoming show >></a>

So how would I adjust that to allow the page to display all records but the side bar link only link to the top record in that list?

Thank you so much for your help so far!

Hi Hannah,

What you can do is just pull the top record off of your $showRecords data set and display that like this:

<?php
// load records from 'shows'
list($showsRecords, $showsMetaData) = getRecords(array(
  'tableName' => 'shows',
  'loadUploads' => true,
  'allowSearch' => false,
));

$show = @$showRecords[0];

?>
<a href="<?php echo $show['_link'] ?>" class="side">View next upcoming show >></a>


Hope this helps

Hi Jason,

That's great except it's pulling in the last record from the list and not the top!!

Hannah

Hi Hannah,

Try adding the orderBy option into the code:

<?php
// load records from 'shows'
list($showsRecords, $showsMetaData) = getRecords(array(
  'tableName' => 'shows',
  'loadUploads' => true,
  'orderBy'     => 'date DESC',
  'allowSearch' => false,
));

$show = @$showRecords[0];

?>

This will sort it by date, newest to oldest.  You can also sort on another field if needed.

Hope this helps!

Hi Hannah,

Another options is to use the end function to get the last item from the array instead:

<?php
// load records from 'shows'
list($showsRecords, $showsMetaData) = getRecords(array(
  'tableName' => 'shows',
  'loadUploads' => true,
  'allowSearch' => false,
));

$show = end($showRecords);

?>

The end function will retrieve the last element from an array, and this avoids having to use the orderBy variable in the getRecords function.

Thanks!

Greg