To make more sense,
c_student_id is pulled from
user_id originally, so when it is a match in
Code:
WHERE #__quiz_r_student_quiz.c_student_id = #__comprofiler.user_id);
it is updated. The
c_passed is the only field option I have to choose from as this is the results given by the quiz, either 0 or 1. I just wanted to add this to the field
cb_trainingpass that is already used to show yes or no, if quiz completed and passed.
The ORDER BY looks to be an option if there is a way to select latest date, as there is a date column. Let me look more into that and some of the other things you have mentioned.
