+---------------------------+ | PCLASS | GEN | CASTE | +---------------------------+ |5th Class | Male | BC | |2nd Class | Female | SC | |5th Class | Female | ST | |2nd Class | Female | BC | +---------------------------+
+----------------------------------------------------------------------+ | CASTE | BC | SC | ST | GTOT | +----------------------------------------------------------------------+ | PCLASS |Male|Female|TOT|Male|Female|TOT|Male|Female|TOT|Male|Female| +----------------------------------------------------------------------+ |2nd Class | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | |5th Class | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | +----------------------------------------------------------------------+ |Total | 1 | 3 | +----------------------------------------------------------------------+
$result = $conn->query("select PCLASS, sum(case when GEN = 'Male' and CASTE='SC' or CASTE='ST' or CASTE='BC' or CASTE='OC' or CASTE='Minority' then 1 else 0 end) Males, sum(case when GEN = 'Female' and CASTE='SC' or CASTE='ST' or CASTE='BC' or CASTE='OC' or CASTE='Minority' then 1 else 0 end) Females, count(*) as Total from student where OID='{$_SESSION["OID"]}' group by PCLASS"); while($row = mysqli_fetch_array($result)) {
OID
PCLASS Males Females Total 2nd Class 1 2 2 5th Class 2 2 2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)