CODEWITHSUNDEEP
phpmysqlset
user2911924
user2911924

Reputation: 331

This simple UPDATE query wont work

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.

Upvotes: 1

Views: 85

Answers (1)

dikirill
dikirill

Reputation: 1903

Try this one:

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

Upvotes: 3

Related Questions