Title: Latest Facebook Comments
Last modified: August 21, 2016

---

# Latest Facebook Comments

 *  [fouldsy99](https://wordpress.org/support/users/fouldsy99/)
 * (@fouldsy99)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/latest-facebook-comments/)
 * On my site, I have a widget which displays Headline – Popular – Comments
    in 
   tabs, Headline and Popular work very well, however because I am using the Facebook
   comments the comments section doesn;t work.
 * You can see an example here, on the right below the ad: [http://worldinsport.com](http://worldinsport.com)
 * Here is the code for the Comments tab, how can I change this to show the facebook
   comments please?
 *     ```
       <?php
       				global $wpdb;
       				$sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_author_email, comment_date_gmt, comment_approved, comment_type,comment_author_url,
       				SUBSTRING(comment_content,1,45) 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 $com_num";
       				$comments = $wpdb->get_results($sql);
       				foreach ($comments as $comment) {
   
       				?>
   
       				<ul class="latest-comments">
   
       <li>
       					<?php echo get_avatar( $comment, '40' ); ?>
       					<strong><?php echo strip_tags($comment->comment_author); ?> says:</strong>
       					<?php echo strip_tags($comment->com_excerpt); ?>...
       					<a>ID); ?>#comment-<?php echo $comment->comment_ID; ?>" title="<?php echo strip_tags($comment->comment_author); ?> on <?php echo $comment->post_title; ?>"><?php echo strip_tags($comment->post_title); ?></a>
   
       </li>
       				<?php } ?>
       ```
   
 * `
    [http://wordpress.org/plugins/facebook/](http://wordpress.org/plugins/facebook/)

The topic ‘Latest Facebook Comments’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/facebook_526fac.svg)
 * [Facebook](https://wordpress.org/plugins/facebook/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/facebook/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/facebook/)
 * [Active Topics](https://wordpress.org/support/plugin/facebook/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/facebook/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/facebook/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [fouldsy99](https://wordpress.org/support/users/fouldsy99/)
 * Last activity: [12 years, 5 months ago](https://wordpress.org/support/topic/latest-facebook-comments/)
 * Status: not resolved