UPDATE error

lands

On my site ive got a update profile , when im trying to update the username they are logged in with im getting the following error??

CODE::
$sql4 = "UPDATE members SET username, password, email, first, last, phone WHERE username=$_SESSION['username']

VALUES ('".$username."','".$password."','".$email."','".$first."','".$last."','".$phone."')";

$res4 = mysql_query($sql4) or die(mysql_error());

ERROR::
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' password, email, first, last, phone WHERE username=aaaa VALUES ('aq' at line 1

leatherback

You forgot the quotes:

$sql4 = "UPDATE members SET username, password, email, first, last, phone WHERE username=\"".$_SESSION['username']."\"

bradgrafelman

There's more than just missing quotes... the entire syntax of your UPDATE query doesn't match what MySQL expects. You might want to visit the MySQL manual page UPDATE syntax to learn what an UPDATE query should look like.

leatherback

bradgrafelman;10985845 wrote:
There's more than just missing quotes... the entire syntax of your UPDATE query doesn't match what MySQL expects. You might want to visit the MySQL manual page UPDATE syntax to learn what an UPDATE query should look like.

Hahahaha, I completely missed that 😃