Hi everybody,
I have this problem, I need to extract the value from a Sql Query, and show it the LIST PAGE from my CONTAINER TABLE, i already have the Count for all the Container records showed on the report, but now I need the Count for the Companies on that Report as well, here is an example:
[codebox]
mysql> select company, count() from container group by company;
+----------------------+----------+
| company | count() |
+----------------------+----------+
| ABC | 3 |
| CMT Trucking | 1 |
| EPM | 6 |
| ghys truking | 1 |
| JTS Services | 2 |
| new star | 2 |
| PLS | 5 |
| PP Trucking | 1 |
| Tuxe Inc | 4 |
+----------------------+----------+
9 rows in set (0.02 sec) <----------- I need this number right here (9 Companies)
[/codebox]
I just need the number and also in which way I can show it, for the Containers Count I found this variable {$global_total_cnt}, but i don't know how can I get the other value.
I'll apreciate any help,
Thanks
