[support] Comments needing approval block

[Neil Coghlan]

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 at 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/ ]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/support/attachments/20090730/43e7b77d/attachment.htm>