= DATE_SUB(CURDATE(), INTERVAL 7 DAY)'; $data_params = new QueryData(); $data_params->addDataParam('s', $_SESSION['S_USERID']); $new_label = $wrapperObj->executeQuery($sql, $data_params); if ($new_label === false) { showierror($sql); } $varTotalNewLabels = count($new_label); // count outstainding # number of releases $varOutstandingReleases = $varTotalESTReleases - $varReleaseReceived; if ($varOutstandingReleases < 0) $varOutstandingReleases = 0; ?>

My Label Summary

All labels
New labels
Releases Expected
Releases Received
Outstanding releases