Querying posts from one category and exclude another

  • Resolved jiraffe

    (@jiraffe)


    15 years, 4 months ago

    Hi all

    I’ve been setting up a portfolio theme and I’ve set it up so that the user can categorise projects in both the ‘featured’ and the ‘portfolio’ categories. The problem I’m having is that in the sidebar I want to display the 3 latest portfolio posts, but exclude the featured projects (as these are already listed above it). The following code works fine for me, with the exception that if a ‘featured’ project is one of the three most recent ‘portfolio’ projects then it only lists 2 posts instead of the desired 3. here’s the code…

    <?php
			query_posts('showposts=3&category_name=portfolio');
			$ids = array();
			while (have_posts()) : the_post();
				if (in_category('9')) continue;
				$ids[] = get_the_ID();
				$portfolio_thumb_image_url = get_post_meta($post->ID, "portfolio_thumb_image_url", true);
				?>

				<li><a href="<?php the_permalink() ?>" rel="bookmark"><img src="<?php echo $portfolio_thumb_image_url ?>" /><span><?php the_title(); ?></span></a></li>

				<?php

			endwhile;
			?>

    So does anyone know a work-around? Perhaps is there a way to subtract from the loop count or something? Any help would be great!

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

  • The problem with query_posts, if I recall, is you can include category x and exclude category y, but if a post in category y is also in category x, it gets included.

    Here’s a solution. Its a slight kludge but it gets the job done. The gist is query for more posts than are needed, skip the ones in the unwanted category, and when more than 3 wanted ones have been processed, skip over the rest. I am querying for 6 posts here:

    <?php	query_posts('showposts=6&category_name=portfolio');
$ids = array();
$i = 0;
while (have_posts()) : the_post();
	if ($i > 3) continue;
	if (in_category('9')) continue;
	$i++;
	$ids[] = get_the_ID();
	$portfolio_thumb_image_url = get_post_meta($post->ID, "portfolio_thumb_image_url", true); ?>
	<li><a href="<?php the_permalink() ?>" rel="bookmark"><img src="<?php echo $portfolio_thumb_image_url ?>" /><span><?php the_title(); ?></span></a></li>
<?php endwhile; ?>
    Thread Starter jiraffe

    (@jiraffe)

    That’s a neat little fix! Thanks for that stvwlf, worked likea charm! ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Querying posts from one category and exclude another’ is closed to new replies.