Reverse order, get last row…

• Symaeon

• January 14, 2024 at 5:19 am

Hi,

I have a repeater field associated with users that outputs invoice totals (see attached).

I have it outputting in reverse order, but ideally I would like to only show the most recent/latest row (3, in this case).

<?php $current_user = wp_get_current_user(); ?>                                              
<?php 
$repeater = get_field('invoices', 'user_' . $current_user->ID);

$order = array();

foreach( $repeater as $i => $row ) {

$order[ $i ] = $row['invoice_number'];

}

array_multisort( $order, SORT_DESC, $repeater );

if( $repeater ): ?>

<ul>

<?php foreach( $repeater as $i => $row ): ?>

<li><?php echo $row['invoice_number']; ?>. <?php echo $row['invoice_total']; ?></li>

<?php endforeach; ?>

</ul>

<?php endif; ?>

Can anyone help?

screenshot-m....png

• John Huebner

• January 14, 2024 at 3:07 pm

// initialize a counter
$counter = 0;
foreach ($repeater as $i => $row) {
  if ($counter == 3) {
    break;
  }
  // output row
  
  // increment counter
  $counter++;
}

• Symaeon

• January 15, 2024 at 2:31 am

Thanks John,

Two questions;

1. Where abouts would this be placed, exactly?
2. Will this always show the latest/last row? It might not be 3, that was just an example of what should be showing in this instance. There could be 20/30/50 rows.

Thanks

• John Huebner

• January 15, 2024 at 7:54 am

You initialize the counter before you’re loop. You put the if statement at the start of your loop. You increment the counter at the end of the loop.

This will show the first X items set by the if statement. Since you are reversing the order of the repeater this means it will show the last X items in reverse order. You can set X for whatever number you want to show. It will show up to that number, so if there are only 2 items then it would only show 2.

• Symaeon

• January 15, 2024 at 9:15 am

Thanks John, much appreciated 👍

• Symaeon

• January 19, 2024 at 4:23 am

Edit – Fixed, it was my mistake.

Screenshot-2....png