not really. Not only is there no post title displayed with that plugin, but it would often list the same post right under itself.
So while I would want something like this:
First Post (3 comments)
Second Post (4 comments)
Third Post (3 comments)
Even if it did display post titles, it would do something like this:
First Post (3 comments)
First Post (3 comments)
Third Post (3 comments)
Just yesterday I added an option to show it with commentor name and post title. Not quite what you are looking for…but another option.
Awesome, that will definately be a big help.
Unfortunately, it’s giving me some MySQL syntax errors. Any idea why?
Just so you know, here’s the message it’s giving me:
Database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ WHERE .ID=.comment_post_ID AND post_status = ‘publish’ AND po]
SELECT ID, comment_ID, comment_content, comment_author, post_title FROM , WHERE .ID=.comment_post_ID AND post_status = ‘publish’ AND post_password =” AND comment_approved = ‘1’ ORDER BY comment_ID DESC LIMIT 5
Warning: Invalid argument supplied for foreach() in /home/deadyet/domains/deadyetliving.com/public_html/wordpress/wp-content/plugins/recent-comments.php on line 18
I think I should have been doing a LEFT JOIN on the tables instead of the WHERE. I updated it to version 1.11. Let me know how it works.
It’s still givin me the same problem. Where can I check to make sure I got the right version?
In plugins when logged into WP it should tell you the version #
Do you have any comments on your site? It will probably error if there aren’t any comments.
No, there’s comments. And it was indeed the right version. :-/
I had a few things messed up…try the latest version. My fault…sorry!
