dimoss
Well-Known Member
Hi
I am trying to include the following PHP script using Sourcener to get the total count of id's of a list
However I can't get it work. It returns nothing instead of the number expected.
I tried also to put the same code in an J! article but again no number.
Any help?
Thanks
I am trying to include the following PHP script using Sourcener to get the total count of id's of a list
PHP:
<?php
$db = JFactory::getDBO();
$db->setQuery("SELECT COUNT('id') FROM 'fab_adeies'");
$number = $db->loadResult();
echo "The total number is: ".$number;
?>
I tried also to put the same code in an J! article but again no number.
Any help?
Thanks