Skip to main content
added 81 characters in body
Source Link
birgire
  • 67.8k
  • 7
  • 119
  • 251

I think this must have been solved many times here on WordPress Answers.

You could also check out the examples in the Time parameters part in Codex for WP_Query.

Here are two of them (slightly modified to your needs)

Example 1:

// Create a new filtering function that will add our where clause to the query
function filter_where( $where = '' ) {
    // posts in the last 7 days
    $where .= " AND post_date > '" . date('Y-m-d', strtotime('-7 days')) . "'";
    return $where;
}

add_filter( 'posts_where', 'filter_where' );
$slider_query = new WP_Query('posts_per_page=5&cat=3&orderby=highest_rated&order=desc');    
remove_filter( 'posts_where', 'filter_where' );

Example 2:

// Create a new filtering function that will add our where clause to the query
function filter_where( $where = '' ) {
    // posts for May 1 to March 8, 2013
    $where .= " AND post_date >= '2013-05-01' AND post_date < '2013-05-8'";
    return $where;
}

add_filter( 'posts_where', 'filter_where' );
$slider_query = new WP_Query('posts_per_page=5&cat=3&orderby=highest_rated&order=desc');
remove_filter( 'posts_where', 'filter_where' )

assuming that you have this orderby=highest_rated covered with some plugin as you describe in the comment above.

I think this must have been solved many times here on WordPress Answers.

You could also check out the examples in the Time parameters part in Codex for WP_Query.

Here are two of them (slightly modified to your needs)

Example 1:

// Create a new filtering function that will add our where clause to the query
function filter_where( $where = '' ) {
    // posts in the last 7 days
    $where .= " AND post_date > '" . date('Y-m-d', strtotime('-7 days')) . "'";
    return $where;
}

add_filter( 'posts_where', 'filter_where' );
$slider_query = new WP_Query('posts_per_page=5&cat=3&orderby=highest_rated&order=desc');    
remove_filter( 'posts_where', 'filter_where' );

Example 2:

// Create a new filtering function that will add our where clause to the query
function filter_where( $where = '' ) {
    // posts for May 1 to March 8, 2013
    $where .= " AND post_date >= '2013-05-01' AND post_date < '2013-05-8'";
    return $where;
}

add_filter( 'posts_where', 'filter_where' );
$slider_query = new WP_Query('posts_per_page=5&cat=3&orderby=highest_rated&order=desc');
remove_filter( 'posts_where', 'filter_where' )

I think this must have been solved many times here on WordPress Answers.

You could also check out the examples in the Time parameters part in Codex for WP_Query.

Here are two of them (slightly modified to your needs)

Example 1:

// Create a new filtering function that will add our where clause to the query
function filter_where( $where = '' ) {
    // posts in the last 7 days
    $where .= " AND post_date > '" . date('Y-m-d', strtotime('-7 days')) . "'";
    return $where;
}

add_filter( 'posts_where', 'filter_where' );
$slider_query = new WP_Query('posts_per_page=5&cat=3&orderby=highest_rated&order=desc');    
remove_filter( 'posts_where', 'filter_where' );

Example 2:

// Create a new filtering function that will add our where clause to the query
function filter_where( $where = '' ) {
    // posts for May 1 to March 8, 2013
    $where .= " AND post_date >= '2013-05-01' AND post_date < '2013-05-8'";
    return $where;
}

add_filter( 'posts_where', 'filter_where' );
$slider_query = new WP_Query('posts_per_page=5&cat=3&orderby=highest_rated&order=desc');
remove_filter( 'posts_where', 'filter_where' )

assuming that you have this orderby=highest_rated covered with some plugin as you describe in the comment above.

Source Link
birgire
  • 67.8k
  • 7
  • 119
  • 251

I think this must have been solved many times here on WordPress Answers.

You could also check out the examples in the Time parameters part in Codex for WP_Query.

Here are two of them (slightly modified to your needs)

Example 1:

// Create a new filtering function that will add our where clause to the query
function filter_where( $where = '' ) {
    // posts in the last 7 days
    $where .= " AND post_date > '" . date('Y-m-d', strtotime('-7 days')) . "'";
    return $where;
}

add_filter( 'posts_where', 'filter_where' );
$slider_query = new WP_Query('posts_per_page=5&cat=3&orderby=highest_rated&order=desc');    
remove_filter( 'posts_where', 'filter_where' );

Example 2:

// Create a new filtering function that will add our where clause to the query
function filter_where( $where = '' ) {
    // posts for May 1 to March 8, 2013
    $where .= " AND post_date >= '2013-05-01' AND post_date < '2013-05-8'";
    return $where;
}

add_filter( 'posts_where', 'filter_where' );
$slider_query = new WP_Query('posts_per_page=5&cat=3&orderby=highest_rated&order=desc');
remove_filter( 'posts_where', 'filter_where' )