3
// $query = "SELECT * FROM $dbreg.StudentStatus WHERE 1 ORDER BY studentId,acadYear,semester";
$query = "SELECT
studentId
,acadYear
,semester
,studentStatus
,GPA
,creditAttempt
,creditSatisfy
,creditPoint
,GPAX
,sumCreditAttempt
,sumCreditSatisfy
,sumCreditPoint
,createDateTime
,createUserId
,updateDateTime
,updateUserId
,approveSpe
,approver
,refNo
,CONCAT(YEAR(approveDate)-543,'-',MONTH(approveDate),'-',DAY(approveDate)) AS approveDate
,passStatus
, (
SELECT count( studentId ) +1 AS npass
FROM $dbreg.`StudentStatus` ss2
WHERE ss.studentId = ss2.studentId
AND (
ss2.acadYear < ss.acadYear
OR (
ss2.acadYear = ss.acadYear
AND ss2.semester < ss.semester
)
)
AND ss2.passStatus
IN ( 1, 2, 3 )
) AS sy
FROM $dbreg.`StudentStatus` ss
WHERE 1 =1
ORDER BY studentId,acadYear,semester
";
$result = mysql_query($query, $ln_reg);
$num_rows = mysql_num_rows($result);
?>