Get the date of current post: $date = get_the_date(‘Y-m-d’); Get year, month and day from the $date variable. $exploded = explode(‘-‘, $date); $year = $exploded[0]; $month = $exploded[1]; $day = $exploded[2]; Lastly, query the posts that has the same publish date. $args = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘date_query’ => array( array( ‘year’ … Read more
As you’ve discovered, meta queries only work with the post meta table, it is indeed looking for a meta key of post_date. You can’t do timespan queries with a simple query, but we can accomplish this with a combination of a query for the meta key, and a posts_where filter directly on the SQL to … Read more
Take a look at the WordPress Codex: http://codex.wordpress.org/Plugin_API/Filter_Reference/posts_orderby function edit_posts_orderby($orderby_statement) { $orderby_statement = “meta_value DESC”; return $orderby_statement; } add_filter(‘posts_orderby’, ‘edit_posts_orderby’); If you’re making the WP_Query yourself you can change the orderby parameter to meta_value Take a look here: http://codex.wordpress.org/Class_Reference/WP_Query
You have to declare $popular to be global before you use it. Based on the code you’ve posted you haven’t done that. global $popular; $popular[] = 1 //post id=1 $popular[] = 2 //post id=2 $popular[] = 3 //post id=3 However, if you mean the index.php in the theme, that file is not always used. You … Read more
The cat and category_name parameters for WP_Query display “posts that have this category (and any children of that category)”. There are also examples of doing this in the Codex. $query = new WP_Query( ‘cat=4’ ); // or $query = new WP_Query( ‘category_name=staff’ ); I am not 100% sure what you mean by “I need all … Read more
Is there a $wpdb method available that will allow me to create the query, by looping through my query, and then execute it once I’m out of that loop? If you and your loop can construct the proper SQL, then use $wpdb->query. You can run any query you want with that, so whatever version of … Read more
get_query_var works within any code, theme or plugin. But it will only return meaningful data after the query has been processed. So, use it on the init hook or later.
UPDATE wp_posts SET post_author = [NEW_ID] WHERE post_author = [OLD_ID]
These look like 2 separate questions. The first I think is a single vs double quotes issue: Try this: $html=””; foreach ( $recent_across_network as $post ) { $html .= ‘blog_id, ‘.$post->ID.’ ) . ‘”>’ . $post->post_title . ”; } $html .= ”; The line in the foreach is putting $post->ID in single quotes which won’t … Read more
With a WP_Query() you can have all of them what you want in an easy way. See all the arguments available in the Codex. With the following code, we are grabbing all(-1) the posts from wp_posts table, and using the post ID we are grabbing the postmeta items. <?php $productquery = new WP_Query( array( ‘post_type’=>’wpcproduct’,’post_status’=>’publish’,’posts_per_page’=>-1 … Read more