Display Total Number of Submissions

I have been trying for several hours how to get this done, and, well, I just can't seem to wrap my mind around how to do it.

What I am attempting to do is show something like:

Join us here, there are already {cf_id} Users here!

The {cf_id} should be the last or newest {cf_id}.........and there is the problem, just between the user and keyboard.

Anyone able to she any light on how to make the number appear?

Hi cruser;

Try this

<?php
$db =& JFactory::getDBO();
$query = "
  SELECT * 
    FROM ` #__users`
    WHERE `blocked` = 0 ;
";
$db->setQuery($query);
$count = $db->loadResult();
echo "Join us here, there are already $count Users here!";
?>

This may not be the correct query for you . . . but something like this should work.

Bob