Title: php code
Last modified: August 19, 2016

---

# php code

 *  [cinoa](https://wordpress.org/support/users/cinoa/)
 * (@cinoa)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/php-code/)
 * Hi everybody,
    I’m not the php professional, so hopefully someone can help me
   out:
 * HOW TO change tis code
 * <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
 * li><h2>Last Comments</h2>
    <ul id=”recent_comments”> <?php global $wpdb; $sql
   = “SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID,
   SUBSTRING(comment_content,1,80) 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
   DESC LIMIT 4″; $comments = $wpdb->get_results($sql); $output = $pre_HTML; foreach(
   $comments as $comment) { $output .= “\n
    - ID) .
       “#comment-” . $comment->comment_ID . “\” title=\”on ” . $comment->post_title.“\”
      >” .strip_tags($comment->com_excerpt). “…“; } $output .= $post_HTML; echo 
      $output;?> <!– END –>
    - >>>>>>>>>>>>>>>>>>>>>>>>
    - that the output will be:
    - **(authors name) to: titel of article
       only the 5 last comments
    - No exerpt just that.
       PLEEESE!

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Michael](https://wordpress.org/support/users/alchymyth/)
 * (@alchymyth)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/php-code/#post-1288236)
 * please use the code button on top of the editor when you post code.
    it is unrecognizable
   at the moment.
 *  Thread Starter [cinoa](https://wordpress.org/support/users/cinoa/)
 * (@cinoa)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/php-code/#post-1288452)
 * Sorry, I have posted it again, hopefully thats okay?!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘php code’ is closed to new replies.

## Tags

 * [comment](https://wordpress.org/support/topic-tag/comment/)
 * [loop](https://wordpress.org/support/topic-tag/loop/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [cinoa](https://wordpress.org/support/users/cinoa/)
 * Last activity: [16 years, 4 months ago](https://wordpress.org/support/topic/php-code/#post-1288452)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics