WordPress.org

Support

Support » Themes and Templates » Show on category last comment author

Show on category last comment author

  • 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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Up PLEASE ! Realy need help

    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);
    ?>

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

    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);
    ?>

    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 🙂

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Show on category last comment author’ is closed to new replies.