• Resolved lava-team

    (@hungrygolf)


    I have a custom post (it’s called “ait-dir-items”) and 2 categories there.
    On category archive page, I need to get posts which belong to 2 categories.

    get posts from 2 categories

    Codition.
    category1= “food” on “ait-dir-item-category” (food id is 6)
    and
    category2= “cate” on “ait-dir-item-category” (food id is 39)
    and
    post_type=”ait-dir-items”

    I have been trying 3 ways to solve this problem.
    None of them is working well. please advice me how I could fix it.

    1st way
    ———————————————————————–
    query_posts(“cat=6, 39&showposts=5&post_type=ait-dir-item”);
    //query_posts( array( post_type=>’ait-dir-item’, ‘category__and’ => array(6,39), ‘posts_per_page’ => 12, ‘orderby’ => ‘title’, ‘order’ => ‘DESC’ ) );

    while(have_posts()) : the_post();

    echo $title = get_the_title();
    echo $content = get_the_content();
    endwhile;
    when I put “cat=6, 39” or “‘category__and’ => array(6,39)”, no result found.

    2nd way
    ——————————
    global $post;

    $tmp_post = $post;

    $args = array(
    ‘posts_per_page’ => 5,
    ‘post_type’ => ‘ait-dir-item’,
    ‘category__and’ => array(6, 39) // where 1, 2 is cat id
    /*’tax_query’ => array(
    array(
    ‘taxonomy’ => ‘ait-dir-item-special’,
    ‘field’ => ‘id’,
    ‘terms’ => 39 // taxonomy id
    )
    )*/
    );
    $myposts = get_posts( $args );
    foreach( $myposts as $post ) :

    $feat_image = wp_get_attachment_url( get_post_thumbnail_id($post->ID) );
    $thumb = wp_get_attachment_image_src( get_post_thumbnail_id($post->ID), ‘thumbnail_size’ );
    $url = $thumb[‘0’];
    ?>

    <li class=”display_special_items”><img src=”<? echo $url; ?>”/>“><?php the_title(); ?>
    <?php endforeach; ?>
    <?php $post = $tmp_post; ?>
    <li class=”clear”>
    3rd way : relation and AND

    ——————————–
    $custom_terms = get_terms(‘ait-dir-item-special’);
    $other_custom_terms = get_terms(‘ait-dir-item-category’);

    foreach ($custom_terms as $custom_term) {
    foreach ($other_custom_terms as $other_custom_term) {
    wp_reset_query();
    $args = array(‘post_type’ => ‘ait-dir-item’,
    ‘tax_query’ => array(
    ‘relation’ => ‘AND’,
    array(
    ‘taxonomy’ => ‘ait-dir-item-category’,
    ‘field’ => ‘id’,
    ‘terms’ => 6
    ),
    array(
    ‘taxonomy’ => ‘ait-dir-item-special’,
    ‘field’ => ‘id’,
    ‘terms’ => 39
    ),
    ),
    );

    $loop = new WP_Query($args);
    if($loop->have_posts()) {
    echo ‘<h1 style=”margin-top:10px;”>’.$custom_term->name.'</h1>’;

    while($loop->have_posts()) : $loop->the_post();
    echo ‘<h2>‘.get_the_title().’</h2>’;
    endwhile;
    }
    }
    }
    I think I have little problems with these codes. it shows but duplicated and all item posts. how should I fix it?

    Thanks,

Viewing 8 replies - 1 through 8 (of 8 total)
  • I’ll have made a quick & dirty example, of how I think its gonna work 🙂

    Example: http://pastebin.com/Zb8arMkZ
    Of course you need to edit the line inside the query…

    Let me know if it works for you… i’am a little bit tired and need to sleep now 🙂

    Thread Starter lava-team

    (@hungrygolf)

    Thanks Very much for your time 🙂
    unfortunately, It’s not working. it displays “Sorry, nothing to display”.

    As I mentioned when you put ‘category__and’ => array(6,39), or ‘cat=6,39’ it doesn’t display anything.

    query_posts ( array( ‘post_type’ => ‘ait-dir-item’, ‘posts_per_page’ => 12, ‘orderby’ => ‘title’, ‘order’ => ‘DESC’ ) );

    when I remove them, it shows perfectly.

    I am so sorry for bad news and thanks again.
    I hope you have a great dream and good sleep 😀

    Thanks 🙂 I have dreamed about the perfekt query 😀

    Guess I was to tired yesterday to get this working… Custom Post Types has no “catgories” – Custom Post Types uses “Custom Taxonomies” instead of “categories” for normal posts… I’ll try to give you some examples (dont know your configuration in detail) 🙂

    Example 1 'taxonomies' => array('your-taxonomy1','your-taxonomy2')

    <?php
      query_posts ( array( 'post_type' => 'ait-dir-items' , 'taxonomies' => array('your-taxonomy1','your-taxonomy2'), 'posts_per_page' => 12, 'orderby' => 'title', 'order' => 'DESC' ) );
      if ( have_posts() ) : while ( have_posts() ) : the_post();
    ?>

    Example 2 'your-taxonomie' => array(6,39)

    <?php
      query_posts ( array( 'post_type' => 'ait-dir-items' , 'your-taxonomie' => array(6,39), 'posts_per_page' => 12, 'orderby' => 'title', 'order' => 'DESC' ) );
      if ( have_posts() ) : while ( have_posts() ) : the_post();
    ?>

    Please also have a look at:
    http://codex.wordpress.org/Class_Reference/WP_Query#Taxonomy_Parameters

    Thread Starter lava-team

    (@hungrygolf)

    Sounds great for your dream 🙂 and thanks for your time again.

    I have total 3 custom categories on ait-dir-item post type.
    and I need 2 of them air-dir-item-category and ait-dir-item-special.

    I need to get posts “food” (id=6) on ait-dir-item-category and “cate” (id=39) on ait-dir-item-special.

    basically, get posts which checked “food” on ait-dir-item-category and checked “cate” on ait-dir-item-special

    That’s why I think your example 1 should be. but it displays all posts.

    I thought I need to put cat id for each taxonomies.
    Therefore I put terms and like this..

    query_posts ( array( 'post_type' => 'ait-dir-item', 'taxonomy' => 'ait-dir-item-category, ait-dir-item-special', 'terms' => array( 6, 39 ), 'posts_per_page' => 2, 'orderby' => 'title', 'order' => 'DESC' ) );

    But displays all posts 🙁

    anyway thanks for your advice and time!

    Hmm… so have a detailed look to the codex link I’ve posted before…

    Guess you might need a tex query for that…. hope I understand your configuration now 🙂

    Example

    <?php
      query_posts ( array( 
    
        'post_type' => 'ait-dir-items' , 
    
        'tax_query' => array(
    		'relation' => 'AND',
    		array(
    			'taxonomy' => 'air-dir-item-category',
    			'field' => 'id',
    			'terms' => array( 6)
    		),
    		array(
    			'taxonomy' => 'ait-dir-item-special',
    			'field' => 'id',
    			'terms' => array(39)
    		)
    	),
    
        'posts_per_page' => 12,
        'orderby' => 'title',
        'order' => 'DESC' ) );
    
      if ( have_posts() ) : while ( have_posts() ) : the_post();
    ?>

    Thread Starter lava-team

    (@hungrygolf)

    egado, how I can buy you a beer? please let me know!

    Thanks soooo much!!!

    I hope you have a good day and good dream all the time!!!

    Your welcome 🙂 And thanks for the beer – Cheers! 😉

    Thread Starter lava-team

    (@hungrygolf)

    really thanks, I have been spending for 3 days and you save my time. I hope I will help you out one day.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Get posts from 2 categories and different taxonomies.’ is closed to new replies.