query_posts function question

  • sacqigong

    (@sacqigong)


    15 years, 7 months ago

    I’m trying to do something simple, maybe there’s another way, but I’m looking to show posts on my main page for the last 2 (or 3) months. The below code works for one previous month:

    ————–
    $current_month = date(‘m’);
    $current_year = date(‘Y’);

    // Routine to deal with January
    if ($current_month == 1)
    { $current_month = 13;
    $current_year = date(‘Y’) – 1;
    }

    // So go back one month
    $current_month = $current_month – 1;

    query_posts(“year=$current_year&monthnum=$current_month&order=ASC”);

    ————

    But trying to pull the last 2 months, even using this, doesn’t work:
    query_posts(“year=$current_year&monthnum=7,8&order=ASC”);

    Any idea how i can embed 2 months or even a BETWEEN in the query_posts

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    15 years, 7 months ago

    You can’t. WordPress does not support ranges of dates like that.

    Thread Starter sacqigong

    (@sacqigong)

    15 years, 7 months ago

    Ah ha. Cool, thanks for the response. Do you know of any other way to accomplish what I’m looking to do, or am I out of luck?

    ogre

    (@ogre)

    15 years, 7 months ago

    Mysql supports date math:

    select date_sub(curdate(), interval 2 month);

    The function curdate() returns the current date. When specifying the interval note that ‘month’ is not plural.

    It should be possible to create a query that returns all posts for a given period. Unfortunately, you’ll have to get your hands dirty digging in the code.

    Thread Starter sacqigong

    (@sacqigong)

    15 years, 7 months ago

    Thanks for the reply Ogre. In the meantime I got dirty and figured out a way to do this.

    In my query.php, I created a new if statement:

    ————
    // Added by Scott for mulit-month searches
    if ( $q[‘mult_month’] )
    $where .= ” AND MONTH($wpdb->posts.post_date) BETWEEN ” . $q[‘monthnum1’] . ” AND ” .$q[‘monthnum2’] . “”;    ————

    and inserted in above these lines in that file:
    if ( ” !== $q[‘hour’] )
    $where .= ” AND HOUR($wpdb->posts.post_date)='” . $q[‘hour’] . “‘”;

    if ( ” !== $q[‘minute’] )
    $where .= ” AND MINUTE($wpdb->posts.post_date)='” . $q[‘minute’] . “‘”;

    Then, in my index.php, I call a script that determines the date range I want and runs the query_posts, the code looks like this:

    query_posts(“year=$current_year&mult_month=1&monthnum2=$current_month&monthnum1=$last_month&order=DESC&posts_per_page=-1”);

    The above references the mult_month variable to use the modified SELECT statement portion from query.php, then my monthnum1 and monthnum2 are the range for the date I need.

    This will actually give me some possible trouble around December, so I might have to rework it….argh.

    I will look into the function you refer to, thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘query_posts function question’ is closed to new replies.