";
$obj = 0;
//The counters are set to zero
$count_logs = 0;
$count_notifications = 0;
$count_parameters = 0;
while ($obj < pg_numrows($res))
{
$u = pg_fetch_object($res, $obj);
$r = pg_exec($conn, "SELECT count(logid) FROM log WHERE objectid='"
. $u->objectid . "'");
$r = pg_fetch_object($r, 0);
$nr_logs = $r->count;
$count_logs = $count_logs + $nr_logs;
$r = pg_exec ($conn, "SELECT count(paramid) FROM parameter WHERE objectid='"
. $u->objectid . "'");
$r = pg_fetch_object($r, 0);
$nr_params = $r->count;
$count_parameters = $count_parameters + $nr_params;
$r = pg_exec ($conn, "SELECT count(notificationid) FROM notification WHERE objectid='"
. $u->objectid . "'");
$r = pg_fetch_object($r, 0);
$nr_notifications = $r->count;
$count_notifications = $count_notifications + $nr_notifications;
?>
objectname ?>
|
Log entries
|
Parameters
|
Notifications
|
|
TOTALS | ";
echo "$count_logs Log entries | ";
echo "$count_parameters Parameters | ";
echo "$count_notifications Notifications | ";
echo "
";
}
?>