='$date' AND
LABVIST ='1' AND TESTSTATUS ='COMPLETED'
GROUP BY NTIHCNO ORDER BY TIMESTAMP");
while($res = mysqli_fetch_array($result)) {
$dtsxxc = $res['RID']."***".$res['NTIHCNO']."***".$res['AGE1']."***".$res['AGE_GROUP']."***".$res['SEX']."***".$res['RSVNID']."***".$res['DATECREATED'];
echo "
prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND
LABVIST ='1' AND TESTSTATUS ='NOT STARTED'
ORDER BY NTIHCNO DESC");
$result->execute();
$rowcount1 = $result->rowcount();
?>
No. completed
clients
prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND
LABVIST ='1' AND TESTSTATUS ='COMPLETED' AND LABOREDRSTATUS='NULL'
GROUP BY NTIHCNO ORDER BY DATECREATED");
$result->execute();
$rowcount2 = $result->rowcount();
?>
Clients Management - Laboratory
Test date
Requesting unit
Initiated by
Vist type
*
SPECIMEN
HEAMATOLOGY/SEROLOGY
MALARIA
STOOL MICROSCOPY
URINE MICROSCOPY
SWABS.TYPE
WET.PREP
GRAM STAIN
Lab technician
Title
Clients due for urgent results prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND
LABVIST ='1' AND TESTSTATUS ='PROGRESSING'
GROUP BY NTIHCNO ORDER BY DATECREATED");
$result->execute();
$rowcount5 = $result->rowcount();
?>