Level Test Results

Company:
Applicants registered on a specific date
Enter registered date


Level test status:
All applicants
No level test faced


Access denied!
Please login with an authorized account


0 AND `type`=’$type'”;
} else {
$query = “SELECT * FROM `level_test` WHERE ID>0 AND A2_start IS NULL AND B1_start IS NULL AND B2_start IS NULL AND C1_start IS NULL AND `type`=’$type'”;
}} else {
if($ltst == “all”) {
$query = “SELECT * FROM `level_test` WHERE ID>0 AND DATE(created_at)=’$reg_date’ AND `type`=’$type'”;
} else {
$query = “SELECT * FROM `level_test` WHERE ID>0 AND DATE(created_at)=’$reg_date’ AND A2_start IS NULL AND B1_start IS NULL AND B2_start IS NULL AND C1_start IS NULL AND `type`=’$type'”;
}
}
$result = mysql_query($query, $connection) or die(‘cannot show tables’);
$rows = array();
while($row = mysql_fetch_array($result))
$rows[] = $row;
if($result !== false) {
echo ‘

‘;
foreach($rows as $row) {
echo ‘

‘;
}
}
$connection = null;
echo ‘

Name Date Contact NO E-mail A2% B1% B1+% B2%
‘ .$row[‘first_name’].’ ‘.$row[‘surname’]. ‘ ‘ .date($row[‘created_at’]). ‘ ‘ .$row[‘mob_no’]. ‘ ‘ .$row[’email’].
‘;
$A2_PR = $row[‘A2_marks’]*2;
if ($row[‘A2_start’] !== null) { if ($row[‘A2_stat’] !== null) { echo $A2_PR;} else {echo ‘‘.$A2_PR.’‘;} } else { echo ‘—‘; };
echo ‘
‘;
$B1_PR = $row[‘B1_marks’]*2;
if ($row[‘B1_start’] !== null) { if ($row[‘B1_stat’] !== null) { echo $B1_PR;} else {echo ‘‘.$B1_PR.’‘;} } else { echo ‘—‘; };
echo ‘
‘;
$B2_PR = $row[‘B2_marks’]*2;
if ($row[‘B2_start’] !== null) { if ($row[‘B2_stat’] !== null) { echo $B2_PR;} else {echo ‘‘.$B2_PR.’‘;} } else { echo ‘—‘; };
echo ‘
‘;
$C1_PR = $row[‘C1_marks’]*2;
if ($row[‘C1_start’] !== null) { if ($row[‘C1_stat’] !== null) { echo $C1_PR;} else {echo ‘‘.$C1_PR.’‘;} } else { echo ‘—‘; };
echo ‘

‘;
}
?>