Try this.. SELECT * FROM $wpdb->posts p INNER JOIN $wpdb->term_relationships tr ON p.ID = tr.object_id INNER JOIN $wpdb->term_taxonomy tt ON tr.term_taxonomy_id=tt.term_taxonomy_id inner join $wpdb->terms t on t.term_id=tt.term_id and t.slug=’igralni’ WHERE p.post_title LIKE ‘А%’ AND p.post_type=”filmi-i-serialii” AND p.post_status=”publish”
Looks like you’re trying to build up some JSON. Why not use what PHP already provides, which has the advantage of escaping characters too? global $post; $data = array(); if ($loop->have_posts()) { while ($loop->have_posts()) { $loop->the_post(); $thumb=wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ), ‘full’); $thumb2=wp_get_attachment_image_src( get_post_thumbnail_id($post->ID), ‘medium’); $url = rwmb_meta( ‘smb_katalozi’ ); $data[] = array ( ‘image’ => … Read more
I think you need a join. $myquery = $wpdb->get_col( $wpdb->prepare( “SELECT DISTINCT meta_value FROM $wpdb->postmeta INNER JOIN $wpdb->posts ON $wpdb->postmeta.post_id = $wpdb->posts.ID WHERE meta_key = %s AND post_status IN (‘publish’)”, $metakey ) );
Something along the lines of <?php if(have_posts()) { while(have_posts()) { the_post(); the_excerpt(); } } ?> And of course, read the documentation for further info: http://codex.wordpress.org/Main_Page http://codex.wordpress.org/The_Loop
Filter the feed page post limit
You should also use ignore_sticky_posts=1 (it’s default value is 0, so sticky posts aren’t ignored and returned at top of posts list). More on pagination parameters: http://codex.wordpress.org/Class_Reference/WP_Query#Pagination_Parameters
You want get_term_children. function hbg_category_query( $query ) { if( $query->is_main_query() && $query->is_category()) { $categories = get_term_children(1,’category’); $categories[] = 1; // add your special category if (is_category($categories)) { $query->set( ‘posts_per_page’, 32 ); } } return $query; } add_action(‘pre_get_posts’,’hbg_category_query’); Barely tested, but I think that will work.
home_url() uses get_home_url() which in turn uses get_option( ‘home’ ) to retrieve the home url. The code in get_option() includes this: // If home is not set use siteurl. if ( ‘home’ == $option && ” == $value ) return get_option( ‘siteurl’ ); I didn’t unwind all the previous code in the function, but it … Read more
You’ve asked for an array and you are trying to use an object. $key = “sc_event_year”; $value = $today_year; global $wpdb; $results = $wpdb->get_results(“SELECT * FROM $wpdb->postmeta WHERE meta_key = ‘sc_event_year’ AND meta_value = $value”, ARRAY_A); foreach ($results as $result){ echo $post_id = $result[‘post_id’]; // <– here was the problem } Unless $value is a … Read more
Multilingual WordPress page – using URL to determine language?