Want to count the number of relation posts in ACF? You can use this code to create an array of all the songs:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 | <?php $args = array( 'post_type' => 'gig' ); $countArray = []; ?> <?php $loop = new WP_Query($args); ?> <?php if ( $loop->have_posts() ) : while ( $loop->have_posts() ) : $loop->the_post(); ?> <?php $posts = get_field('songs'); if( $posts ): foreach( $posts as $post): setup_postdata($post); if (array_key_exists($post->ID, $countArray)){ $countArray[$post->ID]++; } else { $countArray[$post->ID] = 1; } endforeach; wp_reset_postdata(); endif; ?> <?php endwhile; ?> <?php arsort($countArray); foreach ($countArray as $key => $value) { ?> <?php echo get_post_permalink($key); //=the permalink of the song ?> <?php echo get_the_title($key); //= the title of the song ?> <?php echo $value; //number of times play in a gig ?> <?php } ?> <?php else: ?> <!-- No gigs available --> <?php endif; ?> <?php wp_reset_postdata(); ?> |
If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.