This will get you everything that doesn’t have the meta key fizzbizz. The custom loop part, I lifted directly from the codex. $pageposts = $wpdb->get_results(” SELECT * FROM wp_posts p LEFT JOIN wp_postmeta m ON p.ID = m.post_id WHERE m.meta_key <> ‘fizzbizz’ OR m.metakey IS NULL ORDER BY p.post_date DESC; “); if ($pageposts): global $post; … Read more
I think you’re on the right path with posts_where, something like this should work: <?php function my_filter_where($where){ global $my_current_id; $where .= ” AND ID >= “.$my_current_id; return $where; } // random number I chose for sake of example $my_current_id = 30; add_filter(‘posts_where’, ‘my_filter_where’); $my_posts = new WP_Query(“posts_per_page=5&orderby=ID&order=ASC”); remove_filter(‘posts_where’, ‘my_filter_where’);
Two options- load a page fragment using jQuery’s load method (see Loading Page Fragments), or create your own ajax function to load posts and return it in whatever markup you wish: add_action(‘wp_ajax_my_ajax_get_posts’, ‘my_ajax_callback’); add_action(‘wp_ajax_nopriv_my_ajax_get_posts’, ‘my_ajax_callback’); function my_ajax_callback() { $args = $_POST[‘myargs’]; $collected_child_posts = new WP_Query($args); echo ‘some stuff’; die(); } pass the admin-ajax url to … Read more
Ahh friend, you don’t need such a hard way! This should do… <?php $curauth = get_userdata($row->ID); $user_link = get_author_posts_url($curauth->ID); $posts = get_posts(array( ‘author’ => $curauth->ID, ‘cat’ => 60, //for single category, 60 ‘cat’ => -60, //for excluding this category ‘posts_per_page’ => -1, ) ); $post_count = count($posts); ?> Remove the commented line as per your … Read more
The User Query Class There’s a class to query users. This makes a) more easy and b) more future proof as mostly the internals will change, but not the way you access it. $the_authors = new WP_User_Query( array( ‘role’ => ‘author’ ) ); foreach ( $the_authors as $author ) { // Show what we got: … Read more
This is all sorts of wrong. First don’t use start_wp(); I think that was depreciated 4 years ago. Second your loop is messy, query_posts is for altering the main loop, aka not get_posts. So just write it normally using get_posts or WP Query. $args = array( ‘numberposts’ => 1, ‘offset’=> 0, ‘category_name’ => ‘carrs, dominicks, … Read more
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
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,”>”,””)
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