I'm trying to make a function that returns an array of stats from SQL 'SELECT * FROM', when I don't use a function to return it, it works, but I can't use that array outside of 'function(err, results)'
con.query(`SELECT * FROM MemberPeniz WHERE memberId = '${memberID}'`, function(err, results) {
if(err) {
throw err;
}
console.log(results)
})
I tried this:
function checkTimeoutMEMBERid(memberID) {
con.query(`SELECT * FROM MemberPeniz WHERE memberId = '${memberID}'`, function(err, results) {
if(err) {
throw err;
}
return results
})
}
const result = checkTimeoutMEMBERid(message.author.id);
console.log(result)
but as I say it returns undefined no matter what id I pass in