Error: You have an error in your SQL syntax; check your MySQL server version for the right syntax to use near

Question

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 '('RealName') VALUES ('Louise T') WHERE SteamID='7656119801402xxxx'' at line 1

$mysql_hostname = "localhost";
$mysql_user = "xxxx";
$mysql_password = "xxxx";
$mysql_database = "xxxx";
$prefix = "";
$conn = mysql_connect($mysql_hostname, $mysql_user, $mysql_password);
$connect = mysql_select_db($mysql_database, $conn);


$realname = 'Louise T';
$steamid = '7656119801402xxxx';

$sql="UPDATE users SET ('RealName') VALUES ('". mysql_real_escape_string($realname)  ."') WHERE SteamID='$steamid'";
if (!mysql_query($sql))
{
    die('Error: ' . mysql_error());
} else {
    header("Location: index.php");
    exit();
}

I don't know what this is caused by? I have been checking every single word for if it were interfering with some of the MySQL commands and still seem to get this error..

This is some rules I found online:

You have omitted, or included an unnecessary symbol: !@#$%^&*()-_=+[]{}|;:'",<>/?
A misplaced, missing or unnecessary keyword: select, into, or countless others.
You have unicode characters that look like ascii characters in your query but are not recognized.
Misplaced, missing or unnecessary whitespace or newlines between keywords.
Unmatched single quotes, double quotes, parenthesis or braces.

But I really don't think there is anything like it?

Does this answer your question? When to use single quotes, double quotes, and backticks in MySQL — Dharman
– Dharman ♦, Commented Sep 20, 2020 at 20:38

Abhishek Sharma · Accepted Answer · 2015-11-08 06:22:21Z

3

Your update query is invalid because SET ('RealName') VALUES not a valid Syntax more details

use update like that :-

UPDATE users SET RealName='$realname' WHERE SteamID='$steamid'

For insert :-

Insert into users (RealName) values ('$steamid')

edited Nov 8, 2015 at 6:22

answered Nov 8, 2015 at 6:07

Abhishek Sharma

6,6241 gold badge17 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Abhishek Sharma Over a year ago

thanks... for your support to improving my answer :) - @Drew

bilbodog Over a year ago

Thanks a lot. I get it is just me, there is a little (much) rusty. Long time since I had with SQL to do. Waow. That is embarrassing.

Collectives™ on Stack Overflow

Error: You have an error in your SQL syntax; check your MySQL server version for the right syntax to use near

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related