query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' ")) { while ($row = $result->fetch_assoc() ) { $stddx=$stddx. ""; } } $connect->close(); ?> Ntihc | imm system
query($sql); while($row=$res->fetch_assoc()){ $NTIHCNO = $row['NTIHCNO']; $FIRSTNAME = $row['FIRSTNAME']; $LASTNAME=$row['LASTNAME']; $AGE = $row['age']; $SCHOOLINGSTATUS=$row['SCHOOLINGSTATUS']; $SEX = $row['SEX']; $id=$row['PID']; $PID=$row['PID']; } ?>
Dashboard
Dispensing  
Requisition

history
Stock levels
Logout      
NAGURU TEENAGE INFORMATION AND HEALTH CENTER

DISPENSARY

In-coming drug prescriptions
='$date' AND CHECKAVAILABILITY ='NO' GROUP BY NTIHCNO"; $result = $conn->query($sql); $st =''; $seenid = ""; $x=1; while($row = $result->fetch_assoc()) { if ($seenid==$row['NTIHCNO']) { } else{ $seenid = $row['NTIHCNO']; $st=$st."". "". "". "". "". "". ""; } } $st = $st.'
DATE NTIHC-NO. NAME AGE ACTION
" . $row['DATECREATED'] . "" . $row['NTIHCNO'] . "" . $row['CLIENTNAME'] . "" . $row['AGE1'] . "" . '' . "
'; $conn->close(); echo $st; ?>
Prescription date
* DRUG QTY TIMES PERIOD TOTAL
Prescription comment
Prescriped by Requesting unit
Dispensed by Date
New orders

='$date' AND CHECKAVAILABILITY ='NO' GROUP BY NTIHCNO")) { /* determine number of rows result set */ $row_cnt = mysqli_num_rows($result); printf("%d \n", $row_cnt); /* close result set */ mysqli_free_result($result); } /* close connection */ mysqli_close($link); ?>

Dispensed

='$date' AND CHECKAVAILABILITY ='YES' GROUP BY NTIHCNO")) { /* determine number of rows result set */ $row_cnt = mysqli_num_rows($result); printf("%d \n", $row_cnt); /* close result set */ mysqli_free_result($result); } /* close connection */ mysqli_close($link); ?>

Expiry alerts

0

drug levels

0