This is a little bit of a weird question, however, I have this function:
async function getNumOfSessionForTrainerClientList(req, res, rows, allowedToAddMoreClients, alertMessage) {
var getNumOfSessionForTrainerClientList = "select * from SCHEDULE WHERE USERNAME = ? AND ASSIGNED_TRAINER = ?"
mysqlconn.connect(async function(err) {
if (err) {
console.error('Database connection failed: ' + err.stack);
return;
}
mysqlconn.query(getNumOfSessionForTrainerClientList, [rows.USERNAME, req.session.username], async function(err, sessionData) {
if (err) {
console.log(err);
} else {
//go to checkIfUserPaid
// console.log("Lenght or rows: " + sessionData.length);
console.log(sessionData.length)
console.log(sessionData)
sessionData2.push(sessionData)
res.render('trainerclientlist.ejs', {
data: rows,
trainerFirstName: req.session.firstname,
trainerLastName: req.session.lastname,
allowedToAddMoreClients: allowedToAddMoreClients,
profilePhoto: req.session.profilePhoto,
alertMessage: req.session.selectedalertmessage,
sessionData: sessionData
})
}
})
})
}
what this does it just a query that queries my schedule table, however, I need to get the results from this table for what could be up to 25 people. So i don't want to go and loop the query based on the number of rows i have from rows, so I'm not sure what to do. any ideas?