Show today and future posts

  • xanuex

    (@xanuex)


    14 years, 6 months ago

    Hi guys,

    First of all I hope this is the right topic cause I couldn’t place it in WP-advanced..

    I’ve found a lot of info about this already but I’ve stumbled upon a problem. I’m trying to show a list of posts from the database with a date equal to today or in the future.

    This is the code I use:

    — functions.php

    function my_posts_where_from_today( $where = '' ) {
	$where .= " AND post_date > '" . date('Y-m-d', strtotime('now')) . "'";
	return $where;
}
add_filter( 'posts_where', 'my_posts_where_from_today' );

    — index.php

    <?php query_posts( array( 'category_name' => 'games', 'post_status' => 'future || publish', 'post_type' => 'post', 'post_per_page' => '15', 'orderby' => 'date', 'order' => 'ASC' ) ); ?>

<?php while ( have_posts() ) : the_post(); ?>

  //junk

<?php endwhile; ?>

<?php wp_reset_query(); ?>

    My problem:
    The code works like a charm but the filter is applied to every query. It seems logical but not really what I want.

    How can I apply the above on just this query?

    Thanks in advance,
    Marcel

Viewing 2 replies - 1 through 2 (of 2 total)
  • Michael

    (@alchymyth)

    14 years, 6 months ago

    leave the functions code in functions.php;
    but remove this line from functions.php:

    add_filter( 'posts_where', 'my_posts_where_from_today' );

    and add it before your ‘query_posts()’ line; i.e.

    add_filter( 'posts_where', 'my_posts_where_from_today' );
<?php query_posts( array( 'category_name' => 'games', 'post_status' => 'future || publish', 'post_type' => 'post', 'post_per_page' => '15', 'orderby' => 'date', 'order' => 'ASC' ) ); ?>

    then, after the ‘endwhile’ line, add:

    remove_filter( 'posts_where', 'my_posts_where_from_today' );

    Thread Starter xanuex

    (@xanuex)

    14 years, 6 months ago

    Thanks!
    I tried the first part but forgot to put the remove_filter afterwards 🙂

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Show today and future posts’ is closed to new replies.