Title: Display All Comments
Last modified: August 19, 2016

---

# Display All Comments

 *  Resolved [booyahc](https://wordpress.org/support/users/booyahc/)
 * (@booyahc)
 * [17 years, 6 months ago](https://wordpress.org/support/topic/display-all-comments-1/)
 * Hey All,
 * I am hoping you can help. Is there an easy way to load all comments on the site
   from all posts/categories into one page?
 * Thanks

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

 *  [Mark Jaquith](https://wordpress.org/support/users/markjaquith/)
 * (@markjaquith)
 * [17 years, 6 months ago](https://wordpress.org/support/topic/display-all-comments-1/#post-922598)
 * `<?php include_once(‘path_to_wp/wp-load.php’);
    $comments = $wpdb->get_results(“
   SELECT * FROM $wpdb->comments WHERE comment_approved <> ‘spam'”); foreach ( $
   comments as $comment ) { // put comment loop functions here — copy from your 
   comments template } ?>
 *  Thread Starter [booyahc](https://wordpress.org/support/users/booyahc/)
 * (@booyahc)
 * [17 years, 6 months ago](https://wordpress.org/support/topic/display-all-comments-1/#post-923095)
 * Champion!
 * I’ll give that a go today.
 * I really appreciate your help
 *  Thread Starter [booyahc](https://wordpress.org/support/users/booyahc/)
 * (@booyahc)
 * [17 years, 6 months ago](https://wordpress.org/support/topic/display-all-comments-1/#post-923096)
 * works a charm 😀
 *  [andreasnvj](https://wordpress.org/support/users/andreasnvj/)
 * (@andreasnvj)
 * [17 years, 1 month ago](https://wordpress.org/support/topic/display-all-comments-1/#post-923293)
 * Does this work in 2.7 as well? doesn’t seem to.
 *  i receive following error message:
 * > Warning: include_once(path_to_wp/wp-load.php) [function.include-once]: failed
   > to open stream: No such file or directory in /home/www/brudstykker.petervagn.
   > dk/wp-content/themes/classic/comments.php on line 79
   > Warning: include_once() [function.include]: Failed opening ‘path_to_wp/wp-load.
   > php’ for inclusion (include_path=’.:/usr/share/php:/usr/share/pear’) in /home/
   > www/brudstykker.petervagn.dk/wp-content/themes/classic/comments.php on line
   > 79
 * In addition to an endless loop of all my comments. Any clues?

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

The topic ‘Display All Comments’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 3 participants
 * Last reply from: [andreasnvj](https://wordpress.org/support/users/andreasnvj/)
 * Last activity: [17 years, 1 month ago](https://wordpress.org/support/topic/display-all-comments-1/#post-923293)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics