这个简单的UPDATE查询不起作用

Question

This update code always worked perfectly but suddently it doesnt work anymore..

$result = mysqli_query($con, "UPDATE members SET username='$username', password='$password', email='$email', wage='$wage', rights='$rights' WHERE id='$id'");

While this works:

$result = mysqli_query($con, "UPDATE members SET username='$username' WHERE id='$id'");

In the same situation..

What do I do wrong? Used this before in my script and thats working perfectly. Thanks.

Answer 1

Try this one:

$result = mysqli_query($con, "UPDATE `members` SET `username`='$username', `password`='$password', `email`='$email', `wage`='$wage', `rights`='$rights' WHERE `id`='$id'");