The code is executing without any errors, but the database table does not get updated
id and status are being retrieved from an HTML form
router.get('/update_todo/:todo_id',async function(req,res){
const id = req.body.todo_id;
const status = req.body.complete;
const queryString = "UPDATE todos SET completed = ? WHERE todo_id = ?";
con.query(queryString,[id,status],function(err,rows,fields){
if(err)
{
console.log(err.message)
}
else
{
console.log("Update successful")
}
})
})
The output appears as:
fieldCount 0
affectedRows 0
insertId 0
serverStatus 2
warningCount 0
message "(Rows matched: 0 Changed: 0 Warnings: 0)"
protocol41 true
changedRows 0