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 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 Damon,

I get MySQL Error: Unknown column 'date' in 'order clause' when I use that. I though maybe that's because my fields are listed differently so tried start_date but that then just generated a random record. Then I tried changing my sort order in my CMS to include start_date but I get 

Sorting Error: Check your 'Order By' fields in the sorting tab for invalid field names.
MySQL returned the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'start_date DESC LIMIT 1' at line 1

Any suggestions?

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