If last (based on order, not num)

5 posts by 3 authors in: Forums > CMS Builder
Last Post: April 2, 2009   (RSS)

By rjbathgate - April 1, 2009

Hey,

I need to write an IF statement for is the record is the last one in the (multi record) table.

However, something based on the record num (i.e. IF num = totalRecords) doesn't work as I need it based on the table order rather than num.

For example
2: Hi
3: Hello
4: Bye
1: Goodbye

I need Goodbye to be recognised as the last, even though it's num = 1, it is last as per order.

Note, the table is ordered by another field, DATE (which is date format), not DragSortOrder if that matters.

Cheers in advance
Rob

Re: [rjbathgate] If last (based on order, not num)

By Dave - April 1, 2009

Hi Rob,

Do you need to load all the records or could you just use these options to load the last one?

'orderBy' => 'date',
'limit' => 1,

That will load one record, and you can make it the last one by changing the orderBy (date, or date DESC). If you need to load them all and get the last one you could do something like this:

<?php
$lastRecord = array();
foreach ($records as $record) { $lastRecord = $record;}
?>

Let me know if either of those would work for you.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] If last (based on order, not num)

By rjbathgate - April 1, 2009

Hi Dave,

Yeah, need to display all data, so a limit 1 won't work.

How do I implement this:

<?php
$lastRecord = array();
foreach ($records as $record) { $lastRecord = $record;}
?>

This is what I have at moment:
<?php foreach ($tableRecords as $record): ?>

<?php if (LAST): ?>
IF LAST CONTENT

<?php else: ?>
ELSE CONTENT

<?php endif; ?>
<?php endforeach; ?>

Cheers Dave

Re: [rjbathgate] If last (based on order, not num)

By ross - April 2, 2009

Hi Rob.

I have some code for you to try :).

<?php foreach ($tableRecords as $record): ?>
<?php if ($record == end($tableRecords )): ?>
THIS ONE IS LAST
<?php else: ?>
THIS ONE IS NOT LAST
<?php endif ?>
<?php endforeach; ?>

You can see where the last and not last code should go based on the capital letters.

Let me know if this gets things going for you :).
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/