table statistics

[ebonydabster]

Hello, experts!

so i have many tables city, country, institute, participants

how for instance make a statistics (id quantity in all tables) which can be automatically showing in new menu with material (or some fabrik form idk)?

to add counting on site

so the view will be

Menu --> Site database statistics (at the moment) :

Fabrik form:

Cities: 250 (according id quantity)
Countries: 80
Institutes: 480
Participants: 990

 

[troester]

There are different possibilities:
You can collect your infos via php (inside Fabrik e.g. with calculation elements or outside with something like Sourcerer)
You can create a MySql view and display it via Fabrik
...
http://fabrikar.com/forums/index.php?wiki/php-common-tasks/&redirect=common-php-tasks