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/ ]