You had to use LEFT JOIN to simplify the stuff. By the way, the same can be accomplished using WP_Query and I actualy don’t understand why you don’t want to use it. Also I’ve changed the way you write the query and I’ve not use the hardcoded $table_prefix for answer to be useful for others … Read more
At first, not everyone knows, but definetly should know, that there is a pre_get_posts hook which should, in most cases, be used instead of query_posts. Further, defining only one custom post type results in bringing just one custom post type. It’s correct. When one want to bring both, custom post type and posts, one should … Read more
foreach( $posts_array as $post ) { echo the_title(); } I think the problem is you call the_title() without setup_postdata first If I were you, I’ll simply use $post->post_title. foreach( $posts_array as $post ) { echo $post->post_title; } This is because you are “get_posts”ing within a loop, and setup_postdata will change global variable $post which is … Read more
You should access global variables in php using global keyword.It makes variable( or object, array) visible inside current function we are dealing with. In function wms_output_home_slides you are using $post global variable directly instead access it using global keyword as following. function wms_output_home_slides($cat) { // $cat=”homeslide” global $post; // You Code Goes here } Find … Read more
If I understand you correctly, you need to have post metas in your query. This is where the meta_query parameter of the WP_Query class comes to help. The meta_query is an array of arrays. Example from the codex: $args = array( ‘post_type’ => ‘my_custom_post_type’, ‘meta_key’ => ‘age’, ‘orderby’ => ‘meta_value_num’, ‘order’ => ‘ASC’, ‘meta_query’ => … Read more
You need subqueries. This is really a SQL question but as I know no way to do this with native WordPress functions without looping and running multiple queries here you go. $querystr = ” SELECT DISTINCT {$wpdb->posts}.ID, {$wpdb->posts}.*, (SELECT min(cast(meta_value as unsigned)) FROM {$wpdb->postmeta} WHERE meta_key=’_wp_price’ AND meta_value IS NOT NULL AND meta_value <> 0 … Read more
for a standard query, you can check the amount of posts with: all posts for the query: $wp_query->found_posts and the posts on the page: $wp_query->post_count use that with a conditional statement to switch to the different layouts. example: <?php if ( have_posts() ) : //start of the loop// if ( $wp_query->found_posts <= 4 ) { … Read more
Sticky posts are kept in a serialize array in an option in $wpdb->options with the option_name of sticky_posts. So you will need to pull that option and add an OR to the query. $sticky = get_option(‘sticky_posts’); $qry = “… OR {$wpdb->posts}.ID IN (“.implode(‘,’,$sticky).”)”;
Something like this should work but you haven’t stated where you want to display the CPT pages for games. function display_games_archive( $query ) { if ( !is_admin() || $query->is_main_query() && is_post_type_archive( ‘portcat’ ) ) { $query->set( ‘category__in’, ‘games’ ); return; } } add_action( ‘pre_get_posts’, ‘display_games_archive’, 1 );
You can use get_term_by to retrieve a term by its ID: $term_id = 123; $term = get_term_by( ‘id’, $term_id, ‘location’ ); if( $term ){ echo $term->name; }