Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getQuestions()
- {
- for(x=0;x<sevenQIDs.length;x++)
- {
- var query = connection.query('SELECT QUESTION, OP1, OP2, OP3, OP4, ANS FROM QUESTIONS WHERE QUESTION_ID="'+sevenQIDs[x]+'"', function(err,result,fields){
- if(err){
- throw err;
- }
- else{
- var a = result[0];
- var resTime = [], resAns = [];
- resTime.length = 5;
- resAns.length = 5;
- a.resTime = resTime;
- a.resAns = resAns;
- sevenQues.push(a);
- }
- });
- }
- }
- socket.on('socket1', function(text)
- {
- getQuestions();
- console.log(sevenQues);
- }
- function getQuestions(callback)
- {
- for(x=0;x<sevenQIDs.length;x++)
- {
- var query = connection.query('SELECT QUESTION, OP1, OP2, OP3, OP4, ANS FROM QUESTIONS WHERE QUESTION_ID="'+sevenQIDs[x]+'"', function(err,result,fields){
- if(err){
- throw err;
- }
- else{
- var a = result[0];
- var resTime = [], resAns = [];
- resTime.length = 5;
- resAns.length = 5;
- a.resTime = resTime;
- a.resAns = resAns;
- sevenQues.push(a);
- if(x == sevenQIDs.length-1) callback();
- }
- });
- }
- }
- socket.on('socket1', function(text)
- {
- getQuestions(function(){console.log(sevenQues)});
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement