Evening All.

Currently building a site and need to create a 'Schedule' to display a Presenter that is on air at a particular time.

Using ACF plugin to enter a time that the presenter goes on air which saves the custom field value as a timestamp.

For some reason, I cant get the query to display the presenter that is on air at a certain time. It seems to just show the presenter with the highest timestamp value when compared to the current time timestamp. A simplified version of the code is below.

        <?php $args = array(
            'post_type' => 'presenter',
            'posts_per_page' => '1',
            'meta_key' => 'on_air',
            'orderby' => 'meta_value_num',
            'order' => 'DESC'

        );


        $airquery = new WP_Query( $args ); ?>

        <?php if ( $airquery->have_posts() ) : while ( $airquery->have_posts() ) : $airquery->the_post(); ?>

            <?php
                $now = strtotime(date('d-m-Y H:i:s')); // get current timestamp
                $stored_value = get_field('on_air');   // The saved post timestamp comparing to current timestamp
            ?>

            <?php if( $now > $stored_value )
                {
                    echo the_title();
                }
            ?>

        <?php endwhile; endif; wp_reset_postdata(); ?>

As you can see, i'm querying the posts in the post type, and want to order by meta value, which also doesnt seem to be working.

All I get returned is the post with the greatest timestamp value above the current timestamp.

All very strange. Dont know wether I need to somehow get the value of all the posts and then compare the $stored_value to the $now or not?

Any help would be great!

Cheers

Currently building a site and need to create a 'Schedule' to display a Presenter that is on air at a particular time.

Using ACF plugin to enter a time that the presenter goes on air which saves the custom field value as a timestamp.

For some reason, I cant get the query to display the presenter that is on air at a certain time. It seems to just show the presenter with the highest timestamp value when compared to the current time timestamp. A simplified version of the code is below.

<?php $args = array(
    'post_type' => 'presenter',
    'posts_per_page' => '1',
    'meta_key' => 'on_air',
    'orderby' => 'meta_value_num',
    'order' => 'DESC'

);


$airquery = new WP_Query( $args ); ?>

<?php if ( $airquery->have_posts() ) : while ( $airquery->have_posts() ) : $airquery->the_post(); ?>

    <?php
        $now = strtotime(date('d-m-Y H:i:s')); // get current timestamp
        $stored_value = get_field('on_air');   // The saved post timestamp comparing to current timestamp
    ?>

    <?php if( $now > $stored_value )
        {
            echo the_title();
        }
    ?>

<?php endwhile; endif; wp_reset_postdata(); ?>

As you can see, i'm querying the posts in the post type, and want to order by meta value, which also doesnt seem to be working.

All I get returned is the post with the greatest timestamp value above the current timestamp.

All very strange. Dont know wether I need to somehow get the value of all the posts and then compare the $stored_value to the $now or not?

Any help would be great!