WordPress.org

Forums

Show on category last comment author (6 posts)

  1. dudd, médecine blog
    Member
    Posted 5 years ago #

    Hi,

    Please i need to show on category page :

    the last comment author name with link to the last comment of the post

    else : if there is no comment, link to add comment

    thank's

  2. dudd, médecine blog
    Member
    Posted 5 years ago #

    Up PLEASE ! Realy need help

  3. chinmoy29
    Member
    Posted 5 years ago #

    Please try this sql:

    <?php
    $sql = “SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type,comment_content AS com_excerpt
    FROM $wpdb->comments
    LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID)
    WHERE comment_approved = ’1′ AND comment_type = ” AND post_password = ”
    ORDER BY comment_date_gmt DESC
    LIMIT 1”;
    $comments = $wpdb->get_results($sql);
    ?>
  4. dudd, médecine blog
    Member
    Posted 5 years ago #

    Hi, do not work get "Parse error: syntax error, unexpected T_STRING" in first line (i am a dunky on php mysql :-(

  5. chinmoy29
    Member
    Posted 5 years ago #

    try this again. I get the result form this code.

    <?php
    $sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type,comment_content AS com_excerpt
              FROM $wpdb->comments
              LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID)
              WHERE comment_approved = '1' AND comment_type = '' AND post_password = ''
              ORDER BY comment_date_gmt DESC
              LIMIT 1";
      $comments = $wpdb->get_results($sql);
    ?>
  6. dudd, médecine blog
    Member
    Posted 5 years ago #

    not work in the loop ..

    at the end i get this plugin :
    http://wordpress.org/extend/plugins/comment-plugger/
    http://nickmomrik.com/code/

    thank's :-)

Topic Closed

This topic has been closed to new replies.

About this Topic