This function outputs the total row count of a given query, along with the date and time the query was executed.
Class: bb_main, called as $main
File: bb_main.php (php)
Outputs: Count of records returned by query and date and time of query execution.
$result (db resultset)
$result must contain column called
cnt having the count of total rows returned in query not defined by LIMIT or OFFSET.
SELECT count(*) OVER () as cnt, *
FROM data_table WHERE row_type = 1 LIMIT 10 OFFSET 0