Refer to multiple custom field handling in WP_Query: $args = array( ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘city_1’, ‘value’ => array(‘NY’,’LA’), ‘compare’ => ‘IN’ ), array( ‘key’ => ‘city_2’, ‘value’ => array(‘NY’,’LA’), ‘compare’ => ‘IN’ ) ) ); query_posts($args);
For your second example, I think you’re initiating your Loop incorrectly. You’re declaring $query, which hasn’t been globalized? // Search is working, querying is not global $query_string; // required $posts = query_posts($query_string.’&posts_per_page=3&cat=$catid’); while ( $query->have_posts() ) : $query->the_post(); Try omitting $query from your Loop initiation? // Search is working, querying is not global $query_string; // … Read more
If you want the total count of all the published posts in a particular category you can try this. $all_posts = new WP_Query( array( ‘posts_per_page’ => -1, ‘post_status’ => ‘publish’, ‘cat’ => 3 ) ); echo $all_posts->post_count; or $all_posts = new WP_Query( array( ‘posts_per_page’ => -1, ‘post_status’ => ‘publish’, ‘category_name’ => ‘uncategorized’ ) ); echo … Read more
Dan, First a advice: don’t use query_posts to get your pages. Use get_pages instead. Here is how you can do what you are asking using get_pages. get_pages( array( ‘parent’ => 0, ‘sort_column’ => ‘menu_order’ ) ); You can also specify whether you want to sort in ascending order or in descending order. Default sorting order … Read more
Here is the SQL Query with everything set. This does assume you have the standard wordpress table prefix in your config. update wp_posts set post_title = replace(post_title,”>”,””)
<?php $cats = get_categories(‘child_of=”.get_query_var(“cat’)); foreach ($cats as $cat) : $args = array( ‘posts_per_page’ => 3, // max number of post per category ‘category__in’ => array($cat->term_id) ); $my_query = new WP_Query($args); if ($my_query->have_posts()) : echo ‘<h3>’.$cat->name.'</h3>’; while ($my_query->have_posts()) : $my_query->the_post(); ?> <?php /*general loop output; for instance: */ ?> <a href=”https://wordpress.stackexchange.com/questions/42272/<?php the_permalink() ?>”><?php the_title(); ?></a> <br … Read more
Using query_posts() you can pass ‘post_type=custom-post-type’ it will however not work with a category associated with default posts but instead you can pass the custom taxonomy name are the value taxonomy=taxonomy_value You’ll need to do something like: query_posts(array(‘post_type’ => ‘customposttype’, ‘posts_per_page’ => 72, ‘custom_taxonomy_name’ => ‘custom_taxonomy_value’, ‘order’ => ‘ASC’));
How about something along these lines? function my_filter_where( $where=”” ) { global $post; $where .= ‘ AND post_date <= “‘.$post->post_date.'”‘; return $where; } add_filter( ‘posts_where’, ‘my_filter_where’ ); $query = new WP_Query( $query_string ); remove_filter( ‘posts_where’, ‘my_filter_where’ );
Taxonomy Query Always use get_posts() for sidequeries. query_posts() is only for the Main query and new WP_Query() should be used for the second queries only. Read more here. You can query posts by a taxonomy (category, term, etc.): $cat_posts = new WP_Query( array( ‘tax_query’ => array( ‘relation’ => ‘AND’, array( ‘taxonomy’ => ‘movie_janner’, ‘field’ => … Read more
This method uses a counter and 1 query. Only 3 posts from each post type can ever be displayed. $args = array( ‘post_type’ => array( ‘type1’, ‘type2’, ‘type3’ ), ‘posts_per_page’ => -1 ); $myquery = new WP_Query( $args ); $type1 = 0; $type2 = 0; $type3 = 0; $count = 0; while ( $myquery->have_posts() ) … Read more