Andrei Zhitkov

Wow! This is incredibly expeditious. Thank you very much, Sergey.

One would think it was a simple question, but operantly not.

OK then, I am trying to come up with a mySQL query to accomplish the same thing, although my knowledge of mySQL and PHP is just about non-existent. Here’s what I came up with:

<?php
    $result = mysql_query("SELECT comment_post_ID,comment_author,comment_date
    FROM wp_comments
    WHERE comment_approved = 1
    ORDER BY comment_ID DESC
    LIMIT 1"
    );
    while ($row = mysql_fetch_assoc($result))
    {
       echo $row["comment_author"];
       echo "<br>";
       echo $row["comment_date"];
       echo " <b>>></b> ";
       echo $row["comment_post_ID"];
       echo "<br>";
    }
    echo "End of query!";
?>

The problem with this script is that all the comments for all the posts are pulled out, not just for the related post. I need to enter some sort of criteria to tie comment_post_ID column from table wp_comments and ID column from wp_posts, but so far I tried adding after WHERE
AND wp_comments.comment_post_ID = wp_posts.ID
but then I get syntax errors.

Would anybody know how to do a look-up by the related field only?