List post titles by category?

hi, I’ve been reading this and haven’t had luck making things work. What exactly did you use?

ok just to clarify a little bit. I tried using the follow code and it works in just putting out the most recent posts:

<?php $my_query = new WP_Query('category_id=1&showposts=10'); ?>

<?php while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h2 id="post-<?php the_ID(); ?>">
<a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>">
<?php the_title(); ?></a></h2>
<small><?php the_time('F jS, Y') ?> <!-- by <?php the_author() ?> --></small>
<?php endwhile; ?>

However, I want it to spit out the most recent posts from the current category.

Alphaoide, when you said do example 2 from CODEX, I am a little lost and what I am exactly suppose to do.

It should be:

<?php $my_query = new WP_Query('cat=1&showposts=10'); ?>

Don’t know where category_id comes from, but I don’t recognize it as a valid WP query var.

“I want it to spit out the most recent posts from the current category.”

If you mean when displaying any category:

<?php $my_query = new WP_Query("cat=$cat&showposts=10"); ?>

$cat is a global variable for category queries. Note the double-quotes used to enclose the parameters in this case.

Ok, I found out why it isn’t working for me.

<?php $my_query = new WP_Query("cat=$cat&showposts=10"); ?>

This code works perfectly well when I am adding it in the archive.php.

The thing is I want it to be used right below the actual post which is in single.php. So this is what I used:

<?php foreach((get_the_category()) as $cat) { ?>
<p><?php $my_query = new WP_Query("cat=$cat->cat_ID&showposts=10"); ?>
<?php while ($my_query->have_posts()) : $my_query->the_post(); ?>
<h2 id="post-<?php the_ID(); ?>">
<a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>">
<?php the_title(); ?></a></h2>
<small><?php the_time('F jS, Y') ?> <!-- by <?php the_author() ?> --></small>
<?php endwhile; ?> </p>
<?php } ?>

This works. When I am viewing a post, it creates a list of posts that are in the same category of the post I am viewing. The only problem is that it also lists the post I am viewing in the list. Is there a way to skip the post I am reading?

Difficult to work this along with WP_Query. If you want exactly 10 posts, you first need to query 11; from this you can test on say the post IDs (you’ll want to collect it for the current post’s *before* the custom query), and either pass over the current post if in your query object, or discard the 11th once you have 10 displayed.

Another method would be to set up your own SQL query for the posts in the category so you can avoid the current post entirely. Try swapping out the $my_query = new and while lines with the following:

<p><?php $my_query = $wpdb->get_results("SELECT $wpdb->posts.* FROM $wpdb->posts, $wpdb->post2cat WHERE category_id = '$cat->cat_ID' AND ID = post_id AND post_id <> '$id' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 10"); ?>
<?php while(list(,$post) = each($my_query)) : ?>

It looks complicated (actually, it is complicated), but it should do what you’re after without any additional changes. This version should also incur less overhead.

Almost forgot to mention that if the above doesn’t work, slip this in just above the new $my_query line:

<?php global $post; $id = $post->ID; ?>

Your code kind of works. If I add the following code before your code, it works fine:
<?php foreach((get_the_category()) as $cat) {
$cat->cat_ID;
} ?>

If I add the following or not:
<?php global $post; $id = $post->ID; ?>

I get this error:
“Warning: Variable passed to each() is not an array or object in /home/happy/public_html/wp-content/themes/john-3-col/single.php on line 24”

Kafkaesqui, thanks for your help. ?? Let me know if you see any problems with this and if not, I’ll post my final code so others can use it.

This is the exact code I tested before replying above:

https://guff.szub.net/wp-content/sourceprt.php?file=fragment-32792.php

thanks, Kafkaesqui! your code works:

<?php
if(is_single()) :
global $post; $id = $post->ID;
foreach((get_the_category()) as $cat) :
?>
<p><?php $my_query = $wpdb->get_results("SELECT $wpdb->posts.* FROM $wpdb->posts, $wpdb->post2cat WHERE category_id = '$cat->cat_ID' AND ID = post_id AND post_id <> '$id' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 10"); ?>
<?php while(list(,$post) = each($my_query)) : ?>
<h2 id="post-<?php the_ID(); ?>">
<a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>">
<?php the_title(); ?></a></h2>
<small><?php the_time('F jS, Y') ?> <!-- by <?php the_author() ?> --></small>
<?php endwhile; ?>
</p>
<?php endforeach; endif; ?>

I was doing it a little different when using your previous code which was why it didn’t work for me.

oops. I just realized this. When I use the code, it closes the comments on the post.

“When I use the code, it closes the comments on the post.”

???

Since the code has nothing to do with comments, can you provide more information?

ok, I did more testing. When I place your code above:

<?php comments_template(); ?>

the comments doesn’t show up and it says:

“Comments are closed.”

It doesn’t allow anyone to post comments and old comments does not show up. If I place your code under <?php comments_template(); ?> everything works fine.

You’re using it in The Loop? I wish I knew that before…what’s happening is the code is clobbering the $post object, and comments rather needs it.

Here’s a version that should get along with its neighbors in or out of The Loop:

https://guff.szub.net/wp-content/sourceprt.php?file=fragment-loop-friendly-32792.php

I’ve not included a replacement for the_author() (which was commented out in your original). It can be collected, but would require another SQL query and such, and I didn’t want to complicate the code unless you really really need it.

Note: This is going to be a tad more query-happy than the previous, which benefits from the $post object’s cache. If you can find a way of running it all outside The Loop and still fit in with your layout, I’d recommend that.

Kafkaesqui
you made my day ??
since two or more hours I’m studying the codex and get a headache and need more than one cup of coffee, because I need exactly this query for my categories

ok it is monday and I hate monday

if(is_category
and the rest of your code

and it works like a charm ??

thanks a lot
regards
Monika

oh I hate monday ??

if there is only one post in a category :

Warning: Variable passed to each() is not an array or object in /usr/virtualweb/mydomain.de/html/wp-content/themes/at_nightfall/archive.php on line 64
#############
and if a post is in two categories it shows all post of both categories

is there any way to modify this?
post 1 is in category 2 and 3
but if you are browsing category 2 the posts of category 3 aren’t display?

regards
Monika