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