Ce-Classes.com

LIne number 78, 2003
PackageID= 0
package_CourseID=

SELECT * FROM tblExams WHERE numExamID=’2003′

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=2003 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 = ‘2003’ and numStudentID = ” and dtmDateTime > ‘2020-08-05 05:21:57’ ORDER BY numScoreID DESC LIMIT 1

LIne number 141,ynArchived= 1
numCredits= 3

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

LIne number 213,qry3= SELECT * FROM package_student_ref WHERE student_id = ” AND expiry_date >= ‘2020-08-05’
PackExpire= 2020-08-05
nm3= 52
ynArchived= 1