gistfile1.js

app.post('/getRhymes', function(req, res) {
  var word = req.body.word;
  var rhymes = [];
  var i = query.length;
  var decrement = function(){ if(i <= 0) myevent.emit('finished'); i--});
  
  db.query('SELECT * from dict WHERE word=\'' + word + '\'', function(err, rows, fields) {
    if (err) throw err;
    for(var r = 0; r < i; r++) {
        phoneme_numbers = rows[r].phonemes;
        phoneme.lastVowelPhoneme = phoneme_numbers[1];
        db.query('Select * from dict where word!=\'' + word + '\' AND phonemes_numbers LIKE \'%' + phoneme.lastVowelPhoneme + '\'', function(pErr, pRows, pFields) {
          if (pErr) throw pErr;
          for(var z = 0; z < pRows.length; z++) {
            var value = pRows[z];
            var obj = {};
            obj.rhyme = value.word;
            console.log(obj.rhyme);
            rhymes.push(obj);
            decrement();
          }
        });  
      }         
    }
    console.log(JSON.stringify(rhymes));
    res.writeHead(200, {
      "Content-Type": "application/json"
    });
    res.write(JSON.stringify(rhymes)); //returns "{"test":1}"
    res.end();


  });
})