exports.list = function(req, res){
req.getConnection(function(err,connection){
   /* find user's major */
    var user_major = (function() {
        connection.query('SELECT major FROM user WHERE user_id=' + req.params.id, function (err, row) {
            if (err) {
                console.log("Error Selecting : %s ", err);
            }
            console.log('test inside function: '+ row[0].major);
            return row[0].major;
        });
    })();
    console.log("1 Test outside: " + user_major);

    res.render('main/main',{page_title:'USER MAJOR', data: user_major});
    });
};