Hi,
I’m able to display bulletins from bulletin_group in my template..
Is it possible to count active (not expired) messages?
Example: Messages in the BB: 3
Here is my code:
{if logged_in}
<div id="bulletin-board">
{exp:query sql="SELECT bulletin_date, bulletin_message
FROM exp_member_bulletin_board
WHERE bulletin_group = '1'||'10'
ORDER BY bulletin_date DESC"}
{if no_results}Sorry, No Bulletin Board Posts{/if}
<div class="index-multi">
<h6 class="date intern-news">
<strong>{bulletin_date format="%d"}.</strong >{bulletin_date format="%F"}
{bulletin_date format="%Y"}
</h6>
<div class="edge">
{bulletin_message}
</div>
</div>
{/exp:query}
</div>
{/if}There is probably query solution with COUNT,...
Thanks!