real_escape_string(trim($_GET['q']))); $sql = "SELECT * FROM cmpatientsnewregistration WHERE NTIHCNO = '$id[0]'"; $res = $conn->query($sql); if($res){} else{echo $conn->error; exit();} while($row=$res->fetch_assoc()){ $NTIHCNO = $row['NTIHCNO']; $DATECREATED = $row['DATECREATED']; $FIRSTNAME = $row['FIRSTNAME']; $LASTNAME = $row['LASTNAME']; $OTHERNAME = $row['OTHERNAME']; $SEX = $row['SEX']; $AGE = $row['AGE']; $AGE1 = $row['AGE1']; $SCHOOLINGSTATUS = $row['SCHOOLINGSTATUS']; $HIGHESTLEVELOFEDUCATION = $row['HIGHESTLEVELOFEDUCATION']; $MARITALSTATUS = $row['MARITALSTATUS']; $EMPLOYMENTSTATUS = $row['EMPLOYMENTSTATUS']; $DISTRICT = $row['DISTRICT']; $DIVISION = $row['DIVISION']; $PLACEOFRESIDENCE = $row['PLACEOFRESIDENCE']; $PHONECONTACT = $row['PHONECONTACT']; $MOTHERFIRSTNAME = $row['MOTHERFIRSTNAME']; $MOTHERLASTNAME=$row['MOTHERLASTNAME']; $FATHERFIRSTNAME=$row['FATHERFIRSTNAME']; $FATHERLASTNAME=$row['FATHERLASTNAME']; $LIVINGWITH =$row['LIVINGWITH']; $HEAREDABOUTNTIHC=$row['HEAREDABOUTNTIHC']; $REGISTEREDBY=$row['REGISTEREDBY']; $REGISTEREDBY=$row['REGISTEREDBY']; $RELIGION=$row['RELIGION']; $TRIBE=$row['TRIBE']; } ?> system
NAGURU TEENAGE INFORMATION AND HEALTH CENTER

CLIENT MANAGEMENT SERVICE CARD
Enroll date
NTIHC&NO.
First name
Last name
Other name
Age
Gender
Schooling
Education
Tribe
Religion
Marital status
Employment
District
Division
Residence
Phone No.
Mother name
Father name
Living with
Enrolled by
query($sql); //echo $sql; //echo $res->num_rows; exit(); while($row=$res->fetch_assoc()){ $EID = $row['EID']; $DATECREATED = $row['DATECREATED']; $prob[] = $row['MEDICALPROBLEM']; $top[] = $row['MEDICALTOPIC']; $catg[] = $row['PROBLEMCATEGORY']; $NTIHCNO = $row['NTIHCNO']; $COUNSELLINGDONE = $row['COUNSELLINGDONE']; $URGENCYTYPE = $row['URGENCYTYPE']; $VISTBY = $row['VISTBY']; $PROBLEMBRIEF = $row['PROBLEMBRIEF']; $ACTIONTAKEN = $row['ACTIONTAKEN']; $SERVICE_EPISODE = $row['SERVICE_EPISODE']; $USERINITIAL = $row['USERINITIAL']; $REGISTERACCOUNT = $row['REGISTERACCOUNT']; $AGE = $row['AGE']; $AGE_GROUP = $row['AGE_GROUP']; $SEX = $row['SEX']; $SCHOOLING = $row['SCHOOLING']; } ?> query("SELECT * FROM clientsexamination WHERE NTIHCNO= '$id[0]' GROUP BY DATECREATED"); if($re){} else{echo 'Error : '.$conn->error; exit();} $tox = $re->num_rows; //total results while ($row=$re->fetch_assoc()) { $rex["".$xx.""] = $row['NTIHCNO']; $dats ["".$xx.""] = $row['DATECREATED']; $xx++; } ?>