get_row($wpdb->prepare(
"
SELECT *
FROM wp_misoc_nc16
WHERE CertificateNo = %d
",
$CertificateNo
));

if($ncholder != null){
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";
echo "

";

echo "

Name ".$ncholder->FirstName." ".$ncholder->MI." ".$ncholder->LastName."
Sex ".$ncholder->Sex."
Date of Birth ".$ncholder->DateofBirth."
Educational Attainment ".$ncholder->EducAttainment."
Training Completed ".$ncholder->TrainingCompleted."
Institution ".$ncholder->Institution."
Company ".$ncholder->Company."
Date of Application ".$ncholder->DateOfApplication."
Date of Assessment ".$ncholder->DateOfAssessment."
Assessment Center ".$ncholder->AssessmentCenter."
Assessor ".$ncholder->Assessor."
Certification Date ".$ncholder->CertificationDate."
Expiration Date ".$ncholder->ExpirationDate."

";

}else{
echo "
No data.";
}

}

?>