I would like to create a custom module on my

[steemer473]

I would like to create a custom module on my joomla site where I can pull values from my fabrik tables; I would like to count records in a table (e.g. total count of records with pending status, etc.). How do I go about doing this? Module should look something like this:

Transaction Statistics:Total Pending Transactions: 4*
Total Closed Transactions:6*
Total Closed Pending Approval Transactions:6*

*The values are from my fabrik tables

 

[steemer473]

friendly bump...

 

[troester]

I suggest
create a fabrik form (without table) and 3 calculation elements with code

$db =& JFactory::getDBO();
$q="select count(*) from your-table WHERE your-condition";
$db->setQuery($q);
$x= $db->loadResult();
return $x;

Create a fabrik form module.