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']; } ?>
![]() |
|