";
// get id
@$query = mysqlprocess(MYSQLQUERY, "SELECT parent_id FROM
$mysql_table_parent WHERE nric='$id';");
$row = mysql_fetch_row($query);
@$query = mysqlprocess(MYSQLQUERY, "SELECT applicant_id, applicanttype_id, applicantinfo_id,
school_id, parent_id, package_id, accountinfo_id, otherregion, otherschool FROM
$mysql_table_applicant WHERE parent_id='$row[0]';");
$row = mysql_fetch_row($query);
$id = $row[0];
$applicanttype_id = $row[1];
$applicantinfo_id = $row[2];
$school_id = $row[3];
$parent_id = $row[4];
$package_id = $row[5];
$accountinfo_id = $row[6];
$otherregion = $row[7];
$otherschool = $row[8];
// get joindate
@$query = mysqlprocess(MYSQLQUERY, "SELECT joindate FROM
$mysql_table_accountinfo WHERE accountinfo_id='$accountinfo_id';");
$row = mysql_fetch_row($query);
$joindate = $row[0];
@$query = mysqlprocess(MYSQLQUERY, "SELECT name FROM $mysql_table_applicanttype WHERE
applicanttype_id='$applicanttype_id';");
$row = mysql_fetch_row($query);
echo "";
echo "Applicant type: | ";
echo "
";
echo "";
echo "";
echo "";
echo "| Applicant type: | ";
echo "".$row[0]." | ";
echo " ";
echo "| Join date: | $joindate | ";
echo "
| ";
echo " ";
echo " |
";
// get school info
@$query = mysqlprocess(MYSQLQUERY, "SELECT schoolregion_id, name
FROM $mysql_table_school WHERE
school_id='$school_id';");
$row = mysql_fetch_row($query);
$schoolregion_id = $row[0];
$schoolname = $row[1];
@$query = mysqlprocess(MYSQLQUERY, "SELECT schoolstate_id, name
FROM $mysql_table_schoolregion WHERE
schoolregion_id='$schoolregion_id';");
$row = mysql_fetch_row($query);
$schoolstate_id = $row[0];
$schoolregionname = $row[1];
@$query = mysqlprocess(MYSQLQUERY, "SELECT name
FROM $mysql_table_schoolstate WHERE
schoolstate_id='$schoolstate_id';");
$row = mysql_fetch_row($query);
$schoolstatename = $row[0];
echo "";
echo "School Information: | ";
echo "
";
echo "";
echo "";
echo "| Name: | ".$schoolname." ".$otherschool." | ";
echo "| Region: | ".$schoolregionname." ".$otherregion." | ";
echo "| State: | ".$schoolstatename." | ";
echo "
| ";
echo " ";
echo " |
";
// get applicant info
@$query = mysqlprocess(MYSQLQUERY, "SELECT namee, class, gender, address,
email, contactno, dateofbirth
FROM $mysql_table_applicantinfo WHERE
applicantinfo_id='$applicantinfo_id';");
$row = mysql_fetch_row($query);
echo "";
echo "Applicant Information: | ";
echo "
";
echo "";
echo "";
echo "| Name: | ".$row[0]." | ";
echo "| Class: | ".$row[1]." | ";
echo "| Gender: | ".$row[2]." | ";
echo "| Address: | ".$row[3]." | ";
echo "| Email: | ".$row[4]." | ";
echo "| Contact No: | ".$row[5]." | ";
echo "| Date Of Birth: | ".$row[6]." | ";
echo "
| ";
echo " ";
echo " |
";
if($applicanttype_id == 2)
{
// get parent info
@$query = mysqlprocess(MYSQLQUERY, "SELECT namee, nric, email, contactno, address
FROM $mysql_table_parent WHERE parent_id='$parent_id';");
$row = mysql_fetch_row($query);
echo "";
echo "Parent Information: | ";
echo "
";
echo "";
echo "";
echo "| Name: | ".$row[0]." | ";
echo "| NRIC: | ".$row[1]." | ";
echo "| Email: | ".$row[2]." | ";
echo "| Contact No: | ".$row[3]." | ";
echo "| Address: | ".$row[4]." | ";
echo "
| ";
echo " ";
echo " |
";
}
// get package info
@$query = mysqlprocess(MYSQLQUERY, "SELECT name, price
FROM $mysql_table_package WHERE
package_id='$package_id';");
$row = mysql_fetch_row($query);
echo "";
echo "Package Information: | ";
echo "
";
echo "";
echo "";
echo "| ".$row[0]." | RM ".($row[1]/100)." | ";
echo "
| ";
echo " ";
echo " |
";
// get add package info
@$query = mysqlprocess(MYSQLQUERY, "SELECT addpackage_id
FROM $mysql_table_addpackageorder WHERE
applicant_id='$id';");
echo "";
echo "Additional Package Information: | ";
echo "
";
echo "";
echo "";
while($row = mysql_fetch_row($query))
{
@$query2 = mysqlprocess(MYSQLQUERY, "SELECT name, price
FROM $mysql_table_addpackage WHERE
addpackage_id='$row[0]';");
$row2 = mysql_fetch_row($query2);
echo "| ".$row2[0]." | RM ".($row2[1]/100)." | ";
}
echo "
| ";
echo " ";
echo " |
";
// get edutainment timeslot info
@$query = mysqlprocess(MYSQLQUERY, "SELECT timeslot_id
FROM $mysql_table_applicanttimeslot WHERE
applicant_id='$id';");
echo "";
echo "Edutainment Zone Access Information: | ";
echo "
";
echo "";
echo "";
while($row = mysql_fetch_row($query))
{
@$query2 = mysqlprocess(MYSQLQUERY, "SELECT day, starttime, endtime
FROM $mysql_table_timeslot WHERE
timeslot_id='$row[0]';");
$row2 = mysql_fetch_row($query2);
$day = "";
switch($row2[0])
{
case 1:
$day = "Monday";
break;
case 2:
$day = "Tuesday";
break;
case 3:
$day = "Wednesday";
break;
case 4:
$day = "Thursday";
break;
case 5:
$day = "Friday";
break;
case 6:
$day = "Saturday";
break;
case 7:
$day = "Sunday";
break;
default:
$day = "Full Time";
break;
}
echo "| ".$day." | ";
echo "Start time: ".$row2[1]." | ";
echo "End time: ".$row2[2]." | ";
}
echo "
| ";
echo " ";
echo " |
";
echo "