Here’s a little experiment: You can try the following setup: $args = array( ‘wpse_search_or_tax_query’ => true, // <– New parameter! ‘s’ => ‘some search text’, ‘tax_query’ => array( array( ‘taxonomy’ => ‘category’, ‘field’ => ‘slug’, ‘terms’ => array( ‘some-category-slug’ ), ‘operator’ => ‘IN’, ), ), ); $query = new WP_Query( $args ); where we introduce … Read more
Compare the current time with the UNIX time stamp of the post date: // now minus one day in seconds if ( ( time() – 86400 ) < get_the_date( ‘U’ ) ) { echo ‘<span class=”new”>New!</span>’; }
You are going about this the hard way, and the less efficient way. You already have a Loop on the page. You should be able to use that and that alone. if (have_posts()) { while (have_posts()) { the_post(); if (6 < $wp_query->current_post) { // formatting for your first six posts } else { // formatting … Read more
Order by none doesn’t do what you think it does. If you don’t specify an order, then MySQL doesn’t guarantee any particular order and will simply get the posts in whatever order it has them. Since they were inserted in a particular order, then you’ll probably get them in that order. Since you need the … Read more
First, just pass your arguments to the constructor of WP_Query as this is both cleaner, and the way you’re supposed to do it according to the Codex documentation of the class. You should be constructing things like this: $my_key_query_args = array( ‘post_type’ => ‘attachment’, ‘post_status’ => ‘inherit’, ‘meta_query’ => array( array( ‘key’ => ‘my_key’, ‘value’ … Read more
WP_Query uses the global $wpdb. What you’ll have to do is replace $wpdb, use WP_Query, then set it back when you’re done. global $wpdb; $wpdb_backup = $wpdb; $wpdb = new wpdb( $user, $pass, $db, $host ); # Do your stuff here… # then when done… $wpdb = $wpdb_backup;
array_merge does not work the way you expect/need it to, but honestly I am not sure why you are making this so complicated. All you need is: $args = array( ‘s’ => ‘keyword1 keyword2’, ‘orders’ => ‘DESC’, ‘showposts’ => 60 ); // var_dump($args); // debug $query = new WP_Query($args); var_dump($query->request); // debug The built is … Read more
You’re referencing the global $wp_query object in your function which you’ve reset using wp_reset_query(). You can resolve the pagination by passing your custom $loop WP_Query object to the function. I also changed wp_reset_query to wp_reset_postdata Also you’re making the call to your pagination function in the while loop instead of after it. Your function should … Read more
try using this fancy function that group the posts by term id that Scribu and Mike created: function event_clauses( $clauses, $wp_query ) { global $wpdb; if ( isset( $wp_query->query[‘orderby’] ) && ‘event_location’ == $wp_query->query[‘orderby’] ) { $clauses[‘join’] .=<<<SQL LEFT OUTER JOIN {$wpdb->term_relationships} ON {$wpdb->posts}.ID={$wpdb->term_relationships}.object_id LEFT OUTER JOIN {$wpdb->term_taxonomy} USING (term_taxonomy_id) LEFT OUTER JOIN {$wpdb->terms} USING … Read more
A better approach could be using three queries. First two query retrieve the post ids, and third one query post by ids. // first query $first_ids = get_posts( array( ‘fields’ => ‘ids’, ‘posts_per_page’ => ’10’, ‘post_status’ => ‘publish’, ‘post_type’ => array(‘news’,’partners’), ‘orderby’ => ‘date’, ‘order’ => ‘DESC’ )); // second query $second_ids = get_posts( array( … Read more