Advertisement
Guest User

Untitled

a guest
Jul 7th, 2015
170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. <?php
  2. echo "Current User ID : ".$USER->id."<br />";
  3. $quizsections = mysql_query("SELECT * FROM quiz_sections");
  4. while($quizsectionsrslt = mysql_fetch_array($quizsections)){
  5. echo $quizsectionsheading = $quizsectionsrslt['heading']."<br />";
  6. $quizsectionsquizid = $quizsectionsrslt['quizid'];
  7. $quizsectionsfirstslot = $quizsectionsrslt['firstslot'];
  8. $quizattempts = mysql_query("SELECT * FROM quiz_attempts WHERE `quiz`=$quizsectionsquizid AND `userid`=$USER->id");
  9. while($quizattemptsrslt = mysql_fetch_array($quizattempts)){
  10. $quizattemptsids = $quizattemptsrslt['id'];
  11. $quizattemptsattempt = $quizattemptsrslt['attempt'];
  12. $quizattemptsquiz = $quizattemptsrslt['quiz'];
  13. $questionattempts = mysql_query("SELECT * FROM question_attempts WHERE `questionusageid`=$quizattemptsids");
  14. while($questionattemptsrslt = mysql_fetch_array($questionattempts)){
  15. echo $questionattemptsid = $questionattemptsrslt['id'];
  16. }
  17. }
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement