此更新查询不会更改表值。 不显示错误，值保持不变

Question

Im trying to update my tables using this query. Once I hit 'update' im redirected to the view all page and all values remains the same. No change takes place but Not getting an error either. Please Help!

$sql = "UPDATE myaddressbook.contacts SET (firstName,lastName,nickName,cellNumber,homeNumber,workNumber) VALUES ('$firstName','$lastName','$nickName','$cellNumber','$homeNumber','$workNumber') " ; "UPDATE address SET(street,city,state,country) VALUES('$street','$city','$state','$country')"; "UPDATE contacts SET (email,birthday,memo) VALUES ('$email','$birthday','$memo') id = '{$_REQUEST['id']}'";

Answer 1

Your queries are little bit off. Update queries use UPDATE [table] SET [column] = [value], [column] = [value] ... WHERE [condition], [condition] ... syntax, and it looks like you've confused that with INSERT syntax, which is INSERT INTO [table] ([column], [column], ...) VALUES ([value], [value], ...);

Try the following (hopefully it gives you a good idea of how to rewrite it):

UPDATE myaddressbook.contacts 
   SET firstName = '$firstName', lastName = '$lastName', ... 
   WHERE id = '$_REQUEST["id"]'