what version of wordpress??
in 2.2 just open wp-admin/moderation.php and edit the query,
$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = '0'");
$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = '0' ORDER BY comment_date DESC ");
worked for me
Thread Starter
run4it
(@run4it)
I’m assuming there is not way for me to do this at wordpress.com? I am “playing” around with WordPress over there in order to evaluate it, but will probably go with a paid host when I get ready to launch.
No, of course you cannot do this at wordpress.com
(@run4it)
16 years, 10 months ago
I realize this sounds counter-intuitive, but is there a way to change the order of the comments in the moderation queue so that newsest ones are first? Here’s why I want to do that.
The blog I hope to build will be for a state government agency. We have to moderate every comment but we have been advised that we HAVE TO KEEP every comment that we elect not to publish. This doesn’t extend to spam. The only way I can think to keep it is to leave it in the queue because it appears that there is not a “Do Not Publish” option, only a delete option. This means it will stay in the queue and become a nuisance by virtue of always appearing at the top.
If anyone has another alternative, I’d love to hear it.
Thanks.