Hello,

I need small help with php. This is my code which queries latest 5 post title from database. I would like to query commented and uncommented posts separately and wrote this code:

PHP Code:

<?php
        global $wpdb;
        $posts = $wpdb->get_results("SELECT * FROM wp_posts WHERE post_author = $id AND post_type = 'post' LIMIT 5 ");
        foreach ($posts as $post) {

        if ($post->comment_count >= 1) {
        echo '<li>' . $post->post_title . '</li>';
            }
        else if ($post->comment_count < 1) {
        echo '<li>' . $post->post_title . '</li>';
            }
        } 
        ?>

But there is one big problem. If the latest five posts are all uncommented when I view commented posts it doesn't display anything. I know that it happens because of comparing comments number to 1 and showing posts only after it, but I don't know any better ways.

Can anyone please help?

I'm confused by what you're asking. Do you have any code to show for querying the comments?

If you're just looking to add something into the 'IF' cases, you can always manually print something like "No Comments" or sort through some of the comments with a while loop and a second query.

PHP Code:

<?php
        global $wpdb;
        $posts = $wpdb->get_results("SELECT * FROM wp_posts WHERE post_author = $id AND post_type = 'post'");

    // Number of commented posts
    $counter = 0;

        foreach ($posts as $post) {

    // we have reached 5 commented posts
    if ($counter == 5)
        break;

        if ($post->comment_count >= 1) {
        echo '<li>' . $post->post_title . '</li>';
    $counter++;
            }
?>

This will query all the posts from your DB but display the first 5 commented posts. Same goes for uncommented posts.