this is what I have in a block, alongside some other stats:
<b><span style="color:red;"><?php $count_unpub_comm_tot = db_result(db_query("SELECT COUNT(cid) FROM {comments} WHERE `status` = 1")); echo $count_unpub_comm_tot; ?></span></b> <b>Un</b>published Comments
with Views, I imagine it would be even easier, no? Just use unpublished filter. Preferred to roll my own though.
Neil ----- Original Message ----- From: Steve Kessler To: support@drupal.org Sent: Thursday, July 30, 2009 2:28 PM Subject: [support] Comments needing approval block
I am trying to create a block of comments that need approval. I have tried many iterations of ways to do this and I cannot figure it out. I would like to do this with views. If anyone can give me a suggestion I would appreciate it.
Thanks,
Steve
Steve Kessler
Denver DataMan
303-587-4428
Sign up for the Denver DataMan Free eNewsletter
------------------------------------------------------------------------------
-- [ Drupal support list | http://lists.drupal.org/ ]