Banner image

views/question-card

21 question-card.php QUERY :

SELECT q.id as questionId , p.id as pid ,q.* ,p.* ,u.* ,a.* ,c.* ,(CASE WHEN a.attempt = q.answer THEN "1" ELSE "0" END ) AS correct FROM et_question q LEFT JOIN et_question_parts p ON p.hid = q.id LEFT JOIN et_user u ON u.id = 1 LEFT JOIN et_question_attempt a ON a.qid =q.id AND a.auid="1" LEFT JOIN et_course c ON c.ccourse = q.qcourse WHERE q.qdeleted = 0 AND q.id = "35533" ORDER BY q.answer
The question array to render could come from :
  1. The DB select via getQuestions(SELECTION,'r');
  2. An array set in a content page.

Question data from DB row - Question

Login please   ____________   X

Your Score -

0 / 1

iBiscuits LOGO