LIne number 78, 144
PackageID= 0
package_CourseID= 9011

SELECT * FROM tblExams WHERE numExamID=’144′

1

SELECT ref.*, ex.*, comp.* FROM tbl_companycourseref_kc AS ref, tblExams AS ex, tbl_company_kc as comp WHERE ex.numExamID = ref.course_id AND ref.course_id=144 AND ref.company_kc_id = comp.id AND ex.ynArchived <> 1 ORDER BY ref.company_kc_id

0

LIne number 135,num= 1
num11= 0
sql11= select * from tblUserScore where numScore >= ’75’ and numExamID = ‘144’ and numStudentID = ” and dtmDateTime > ‘2025-08-23 10:05:27’ ORDER BY numScoreID DESC LIMIT 1

LIne number 141,ynArchived= 1
numCredits= 5

LIne number 190,query22 = select * from tblUserPayments where numStudentID = ” and numExamID = ‘9001’ and dtmPaymentDate >= ‘2025-08-23’ ORDER BY numPaymentID DESC LIMIT 1
pay= 1
pay= 1
ispckFound= 2
pckgStndRefSt= select * from package_student_ref where student_id =” AND expiry_date >’2025-08-23′
, numCredits= 5

LIne number 213,qry3= SELECT * FROM package_student_ref WHERE student_id = ” AND expiry_date >= ‘2025-08-23’
PackExpire= 2025-08-23
nm3= 2
ynArchived= 1 , packageID=9001