Never ever use query_posts, it creates an endless amount of issues as it breaks the main query object on which so many build in functions, custom functions and plugin rely on. It is pure evil and you should avoid it as such as well. For custom queries, use WP_Query or get_posts, if you simply need … Read more
There is date_query which can handle this and an SQL query is not a good practice when you can take advantage of WordPress Query API: $pid = 1; // post ID here $args = array( ‘posts_per_page’ => -1, ‘post_type’ => ‘post’, ‘date_query’ => array( array( ‘year’ => get_the_date(‘Y’, $pid), ‘month’ => get_the_date(‘m’, $pid) ), ), … Read more
If you want to compare dates in a MySQL statement, you should store dates and times using MySQL datetime format: YYYY-MM-DD HH:MM:SS (PHP format Y-m-d H:i:s) Then, you can compare dates easily, and ‘type’ => ‘date’ in the meta query argument should work as expected: $start_date = date(‘Y-m-d’, strtotime($date.” +15 days”)); $end_date = date(‘Y-m-d’,strtotime($date.” -15 … Read more
If News is a category of posts, then: First, find out the category ID, login to wp-admin, go Posts->Categories, mouse over the ‘News’ category, and cat id should be shown under the left corner of the browser (for chrome this works, not sure about other browsers). Add the following code into your function.php function my_news_category( … Read more
This is how you can get the post object of a page with a matching path, minus the /en part: $page_path = get_page_uri( get_queried_object_id() ); // en/page/child-page $target_page_path = str_replace( ‘en/’, ”, $page_path ); // page/child-page $target_page = get_page_by_path( $target_page_path ); // WP_Post of target page.
Maybe with SQL, but I wouldnt suggest it, so you have two options: Query a full list, and then check your condition on each post retrieved. or Save the product of those three fields in another meta field, which can then be queried. EDIT: For the second method, it really depends on the context. if … Read more
I think something like this should do the job: $meta_query = array( array( ‘key’ => ‘foo’, ‘compare’ => ‘EXISTS’, ), ); $args = array( ‘meta_query’ => $meta_query ); $query = new WP_Query( $args ); if ( $query->have_posts() ) { while ( $query->have_posts() ) { $query->the_post(); $post_id = get_the_ID(); } } else { // no posts … Read more
There is really no reason to use raw sql to query posts. You can accomplish just about any type of query using the WordPress API. For full reference see the codex, Function Reference query posts. Try the following: global $post; $args=array( ‘post_type’ => ‘tutorial’, ‘orderby’ => ‘comment_count’, ‘posts_per_page’ => 10 ); $posts= query_posts($args); foreach ($posts … Read more
The current page number is available in a global variable $paged. if ( ! isset ( $GLOBALS[‘paged’] ) or ( $GLOBALS[‘paged’] < 2 ) ) { // run your code }
It was correctly pointed out what the issue is, but I also want to explain it so you have better idea of mechanics: when you use query_posts() it writes down generated WP_Query object into global $wp_query variable; have_posts() and the_post() functions are wrappers for methods of same name called using global $wp_query object; so what … Read more