query("SELECT * FROM ntihcdrugs")) { while ($row = $result->fetch_assoc() ) { $stss=$stss. ""; } } $connect->close(); ?>
| Clients due for HCT / Counselling | ='$date' AND SERVICETYPE ='COUNSELLING SERVICES' AND INSVCSTATUS ='NO' AND DATATYPE = 'ON SITE' GROUP BY NTIHCNO ORDER BY TIMESTAMP")) { $row_cnt = mysqli_num_rows($result); printf(" %d \n", $row_cnt); mysqli_free_result($result); } mysqli_close($link); ?> | Outreach clients due for entry | prepare("SELECT * FROM cmpatientsregistration WHERE SERVICETYPE ='OUTREACH' AND INSVCSTATUS ='NO' GROUP BY NTIHCNO ORDER BY NTIHCNO DESC"); $result->execute(); $rowcount3 = $result->rowcount(); ?> |
|---|