Hi @Ryan Long:
You have two problems:
- You need to wrap the result of
date( 'Y-m-d' , $newdate );
in a SQLDATE()
function, and - You define
$ayearago
outside of thefilter_where()
function so it’s not in scope within the function. You need to move the code that sets$ayearago
into thefilter_where()
function like this:
function yoursite_filter_where($where="") {
$today = date('Y-m-d');
$newdate = strtotime ( '-1 year' , strtotime ( $today ) ) ;
$ayearago = date( 'Y-m-d' , $newdate );
$where .= " AND post_date >= DATE('{$ayearago}')";
return $where;
}
Let me know if that works for you…
Related Posts:
- How to Get All Posts with any post status?
- posts_per_page no limit
- How can i get count from query post
- query_post by title?
- Why query_posts() isn’t marked as deprecated?
- Alternative to query_posts for main loop? [duplicate]
- how to query posts by category and tag?
- Using WP_Query to Query Multiple Categories with Limited Posts Per Category?
- Order by meta value or date?
- How do I query by post format in WordPress 3.1
- Display posts of the last 7 days
- Is there a way to exclude the content from the post variable to save on RAM usage?
- Filtering posts by post meta data
- How to query_posts using meta_query to orderby meta_key AND have a secondary sort by date?
- Query posts by custom taxonomy ID
- Display/query post formats
- How to query post by user role?
- How to return results of a get_posts() in explicitly defined order
- Help to condense/optimize some working code
- How to set posts per page using WP_Query()
- query_posts exclude a meta key
- How do I create a random post that will last for a day
- Ensuring sticky posts are retrieved first (without using two queries)?
- Determine if more posts are available than was asked for in `query_posts()`?
- Modify main WordPress loop with a parse_query filter
- query_posts() in function makes global $wp_query out of sync?
- Limiting query_posts to 1, regardless of sticky post?
- How to make “sticky” pages (and query by them)
- Query posts: how to exclude results if post is in multiple categories
- query_posts ->using meta_compare / where meta value is smaller or greater or equals
- Problem with ‘post__not_in’
- How to order posts by descending comment count on taxonomy page?
- Sort posts alphabetically by custom field value, insert divider between different letters
- Is it better practice to use query_posts, WP_Query, or get_posts to create various custom loops within a Page?
- WP 5.8 “Query Loop” block: where to place custom query?
- Sort X categories by last update and show image
- Custom Post Type “Event”: chronological list of recurring events
- using post__in allow duplicate post id
- Pagination on archive.php page
- WordPress Custom Query
- Best way to load page content in Fancybox popup?
- How should I intercept the main query and inject custom join / order by / group by criteria
- advice on creating a ‘related posts’ query like the one used on stackexchange
- order post my meta value m/d/y format with year as included value
- Order by meta value, pro first, then free
- Having trouble generating pagination links on custom query
- How to create an attachments archive with working pagination?
- _wp_page_template to dynamically use template
- Using dynamic conditions in ‘posts_where’ filter
- Help altering a query to exclude all but standard post format
- List users with the most total posts view
- Schedule Sticky Posts
- Use union/intersection query_posts variables in uri request parameter form?
- query_posts doesn’t order by title
- How to limit search to first letter of title?
- query_posts and pagination, still stuck after much research
- Query posts by taxonomy term name
- Sorting problem with ‘query_posts’ funcion in wordpress. Sort by custom field not working
- Total Count of Posts NOT in Selected Categories?
- Custom query with query_posts doesn’t show post without certain meta_key
- how could I get the pagination as I want to when query posts using get_posts function
- Counter code for paginated category pages in wordpress
- Post Title displaying but not in the wrapped HTML I need
- Author List page: Exclude based on last post date
- WordPress Search Filter Only for Page with Child of Child of Child of Child of Child
- Replace query_posts with pre_get_posts
- How to sort by meta value?
- query_posts sort in multiple directions
- Filter query_posts by tag slug on “Tag Archive” page (when tag is 2 or more words)
- pagination in author.php template returns 404 error
- get_post_meta causes database queries
- Problem with single-page for my custom post
- How to ensure that is_search() return false after query_posts
- Warning: urlencode() expects parameter 1 to be string, array given in and not getting the preffered output
- How to modify the query to exclude posts by slug?
- query recent posts from several categories
- Inserting Post Using wp_insert_post. How to Fill Yoast Plugin SEO Fields
- Show Posts From Same Category OR Same Tag
- Post count per (day/month/year) since blog began
- Example Query Posts Showing the Latest Post with the Featured Image
- Dynamically excluding current page id
- Why is that gdsr_sort=thumbs (GD start rating plugin) only works with query_posts and not with WP_Query?
- How do i paginate query_posts with numeric pagination?
- Query_posts $query_string
- How to make the list of post and load on same page with sub-pages [closed]
- Using database meta_values to calculate new post order using pre_get_posts or a ‘request’ hook
- exclude ids through post__not_in
- How to order posts by slug using query_posts/ Wp_query
- How to get 4 Posts after the 5 most recent ones
- Query 1 taxonomy term, exclude another
- Order by meta_key with two meta_queries
- How to order results by date and meta key?
- Pagination on custom query
- Search stores (custom postcode field) within 5, 10, 15 miles of user inputted postcode.. Code modification
- Ordering terms before displaying posts
- What is the difference between “manage_{$post_type}_posts_columns” and “manage_edit-{$post_type}_columns”?
- Sort Posts by Multiple Meta Values [duplicate]
- Querying posts with meta value that begins with a certain pattern
- How to show only today’s post?
- Different number of posts on the front page