How to fix error with SQL query?

Question

PHP

Please help me to fix the error in SQL query:

$result = mysql_query("UPDATE `users` SET `name`='".$name."',`surname`='".$surname."' WHERE `email`='".$email."' ");

Answer 1

For the future, I advise you to forget about functions like mysql_function () and rather move to mysqli or PDO