Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. function getQuestions()
  2. {
  3. for(x=0;x<sevenQIDs.length;x++)
  4. {
  5. var query = connection.query('SELECT QUESTION, OP1, OP2, OP3, OP4, ANS FROM QUESTIONS WHERE QUESTION_ID="'+sevenQIDs[x]+'"', function(err,result,fields){
  6. if(err){
  7. throw err;
  8. }
  9. else{
  10. var a = result[0];
  11. var resTime = [], resAns = [];
  12. resTime.length = 5;
  13. resAns.length = 5;
  14. a.resTime = resTime;
  15. a.resAns = resAns;
  16. sevenQues.push(a);
  17. }
  18. });
  19. }
  20. }
  21.  
  22. socket.on('socket1', function(text)
  23. {
  24. getQuestions();
  25. console.log(sevenQues);
  26. }
  27.  
  28. function getQuestions(callback)
  29. {
  30. for(x=0;x<sevenQIDs.length;x++)
  31. {
  32. var query = connection.query('SELECT QUESTION, OP1, OP2, OP3, OP4, ANS FROM QUESTIONS WHERE QUESTION_ID="'+sevenQIDs[x]+'"', function(err,result,fields){
  33. if(err){
  34. throw err;
  35. }
  36. else{
  37. var a = result[0];
  38. var resTime = [], resAns = [];
  39. resTime.length = 5;
  40. resAns.length = 5;
  41. a.resTime = resTime;
  42. a.resAns = resAns;
  43. sevenQues.push(a);
  44. if(x == sevenQIDs.length-1) callback();
  45. }
  46. });
  47. }
  48. }
  49.  
  50. socket.on('socket1', function(text)
  51. {
  52. getQuestions(function(){console.log(sevenQues)});
  53. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement