[SOLVED] MySQL update problem

[john6384]

I am trying to run this query although I get this error:

//Assign the query
$query = "UPDATE webusers SET Name='$name' Initials='$initials' Pass='$password' Email='$email' WHERE ID=$ID";

//Execute query
$result = mysql_query($query);
if(!$result){
	die("Could not update user on database: <br />".mysql_error());
}

Could not update user on database:

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 '(ID=11 Name='Doug' Initials='DB' Pass='pass' Email='[email protected]') WHERE ID=11' at line 1

 

The syntax looks fine.

 

Please help and give reasons for this.

Cheers

[djpic]

I had the same problem.  Try this:

	$query = "UPDATE webusers SET `Name`='$name' `Initials`='$initials' `Pass`='$password' `Email`='$email' WHERE `ID`=$ID";

[john6384]

Could not update user on database:

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 '`Initials`='MBs' `Pass`='michelle' `Email`='[email protected]' WHERE `ID`=10' at line 1

 

Thats the error I get now.

Cheers for reply though.

[djpic]

Need to use commas as well.

$query = "UPDATE webusers SET `Name`='$name', `Initials`='$initials', `Pass`='$password', `Email`='$email' WHERE `ID`=$ID";

[john6384]

That did it - cheers mate.

 

Solved.