Reply To: Query not running as expected

• Shoxt3r

• February 7, 2022 at 8:13 pm

Ok, so after some thought I had a feeling that I had to specify that I wanted to have both queries return true for it to display the relevant data. I adjusted my query to include a “relation” but still the incorrect results are showing for Coming Soon, and no results are pulling through for Now Showing.

https://apexcinemas.andrewcourtney.co.uk/coming-soon/
https://apexcinemas.andrewcourtney.co.uk/now-showing/

Below are the amended queries for each page:

Coming Soon

    $comingSoonFilms = new WP_Query(array(
        'post_type' => 'film',
        'posts_per_page' => -1,
        'order' => 'ASC',
        'meta_query' => array(
            'relation' => 'AND',
            array(
                'key' => 'film_releasedate',
                'value' => $dateToday,
                'type' => 'DATE',
                'compare' => '>',
            ),
            array(
                'key' => 'film_active',
                'value' => '1',
            ),
        )
    ));

Now Showing

    $nowShowingFilms = new WP_Query(array(
        'post_type' => 'film',
        'posts_per_page' => -1,
        'order' => 'DESC',
        'meta_query' => array(
            'relation' => 'AND',
            array(
                'key' => 'film_releasedate',
                'value' => $dateToday,
                'type' => 'DATE',
                'compare' => '<',
            ),
            array(
                'key' => 'film_active',
                'value' => '1',
            ),
        )
    ));

If any other details would be helpful let me know!

Thanks in advance.