You can’t alter a page query via pre_get_posts (in any fashion I’ve tried) to something other than a page query. If you look at the generated SQL, it’s trying to query all your post types for a pagename of new. If you set pagename to null, it’ll return posts, but it will disregard any taxonomy … Read more
You need to add Category Parameters to your query array. $arguments = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘paged’ => $paged, ‘showposts’ => $postcount, ‘category_name’=> ‘your-category-slug’ );
WordPress does not have relationship support among the posts. So for you to do that you have create a new table to store the post id and the linked post id. You need to do custom query every time that table needs to be updated.
ok not the most handsome solution but it works i transported the update function to update.php also wp-load.php $(“.col_visitor”).click(function(){ visitorID = $(this).attr(‘id’); //alert(‘testing ‘+visitorID); $.ajax({ url: ‘update.php’, data: {action: visitorID}, type: ‘post’, success: function(output) { //alert(output); window.location.reload(); //reload so we see the updated values } }); });//#end click
Arbitrary SQL query can be run via wpdb by using get_results() method: $results = $wpdb->get_results( $query ); You can work through documentation for wpdb at Codex to gain basic understanding of how it works.
I’m not sure this is possible. Why do you need a page template? Why can’t you use a custom post type archive, which is built-in to WordPress ( if you register the post type with has_archive set to true). I’m ignoring all your other possible $args, because I don’t know how you are registering this … Read more
You have to enclose the OR part to brackets: $sql = “SELECT ID,post_title,post_content,post_date,post_type FROM {$wpdb->posts} WHERE (post_content LIKE {$stuff}) AND post_status=”publish” AND post_type=”{$post_type}” AND ID != {$post->ID} LIMIT {$limit}”; $results= $wpdb->get_results($sql); Try this one: SELECT ID,post_title,post_content,post_date,post_type FROM wp_posts WHERE (post_content LIKE ‘%Battery%’ OR post_content LIKE ‘%Watcher%’ OR post_content LIKE ‘%Widget%’ OR post_content LIKE ‘%matches%’ OR … Read more
Here’s an example using WP_Query‘s meta_query to query posts between two meta key values: $meta_query = array( array( ‘key’ => ‘event_date’, ‘value’ => array( $date_start, $date_end ), ‘compare’ => ‘BETWEEN’ ) ); $args = array( ‘posts_per_page’ => -1, ‘meta_key’ => ‘event_date’, ‘orderby’ => ‘meta_value’, ‘meta_query’ => $meta_query ); $results = new WP_Query( $args );
Well first of all, we can get rid of all the query_posts business in the template. There’s always a better method than using query_posts. If the primary goal is to have 5 posts on the first page and 4 on all subsequent pages, we can do that very easily before the query happens via a … Read more
Displaying posts by year