app.get('/sort', (req, res) => {
var tabelle = req.params.table;
let sql = "SELECT * FROM users ORDER BY tabelle DESC;";
let query = connection.query(sql, (err, rows) => {
if(err) throw err;
res.render('user_index', {
title: 'CRUD Operation using NodeJS / ExpressJS / MySQL',
users: rows
});
});
});
In my CRUD application, I am trying to implement sorting functionality in MySQL based on the value of a variable called tabelle. However, I'm facing challenges in getting this to work effectively. The application is built using technologies like Node.js, Express, ejs, and MySQL.