Hi Krikor,
Unfortunately I did It but It does not work for me. Still Showing Code despite the "result"


Here I prepare custom module
i.imgur.com/PRdq1vt.png

And this is the result, on the right
i.imgur.com/Mq7ZgI5.png

Sorry, I am a noob! :)

You forgot the <?php ?> brackets for the first part of the code.

for non-Devs like me: this works

<?php
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__users";
$db->setQuery($query);
$result = $db->loadresult();?>
<?php echo "$result" ?>

Thank you all for helping me!

I changed this line

to retrive total number of Items!

Nice to hear that you got it working Giovanni.