query($sql); while($row=$res->fetch_assoc()){ $NTIHCNO = $row['NTIHCNO']; $FIRSTNAME = $row['FIRSTNAME']; $LASTNAME=$row['LASTNAME']; $AGE = $row['age']; $SCHOOLINGSTATUS=$row['SCHOOLINGSTATUS']; $VISTTYPE=$row['VISTTYPE']; $DATECREATED=$row['DATECREATED']; $SEX = $row['SEX']; $id=$row['PID']; $PID=$row['PID']; } ?>

Dashboard
Home       
Register
Referal
Reports   
Waiting

NAGURU TEENAGE INFORMATION AND HEALTH CENTER

REGISTRATION DESK
NTIHC No.
Client name
Age
User initial
Visit date
Service type

Vist type
Data type

Clients due for Medical prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND SERVICETYPE ='MEDICAL SERVICES' AND INSVCSTATUS ='NO' ORDER BY NTIHCNO DESC"); $result->execute(); $rowcount11 = $result->rowcount(); ?> Pending for M.H.Services prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND SERVICETYPE ='PREGNANCY RELATED SERVICES' AND INSVCSTATUS ='NO' GROUP BY NTIHCNO ORDER BY DATECREATED"); $result->execute(); $rowcount22 = $result->rowcount(); ?>

Due for counselling services prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND SERVICETYPE ='COUNSELLING SERVICES' AND INSVCSTATUS ='NO' GROUP BY NTIHCNO ORDER BY DATECREATED"); $result->execute(); $rowcount13 = $result->rowcount(); ?> Due for other services prepare("SELECT * FROM cmpatientsregistration WHERE TIMESTAMP >='$date' AND SERVICETYPE ='OTHER SERVICES' AND INSVCSTATUS ='NO' GROUP BY NTIHCNO ORDER BY DATECREATED"); $result->execute(); $rowcount24 = $result->rowcount(); ?>

Search client info

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ''; echo ""; } ?>
NO NTIHC.NO. CLIENT.NAME AGE MOTHER.NAME. POST EDIT
".$res['PID']."".$res['NTIHCNO']."".$res['FIRSTNAME']." ".$res['LASTNAME']."".$res['AGE1']."".$res['MOTHERFIRSTNAME']." ".$res['MOTHERLASTNAME']."     Click


='$date' GROUP BY USERINITIAL ASC"); while($row1=mysqli_fetch_array($query1)){ ?>
SERVICE DATE SERVICE PROVIDER REGISTRATION DESK SERVICE TYPE TOTAL
MEDICAL SERVICES COUNSELLING SERVICES PREGNANCY RELATED