Error in MYSQL syntax with WHERE command

Question

Getting this error-

Not sure why, I have looked over it several of times.

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 'WHERE agentclient = 'admin'' at line 1

In this code-

$sql = mysql_query("UPDATE agentclient SET email='$email2', phone='$phone2', Streetaddress='$address2', faxnumber='$faxnumber2', website='$website2', bio='$bio2', WHERE agentclient = '$agentclient2'") or die(mysql_error());

You have an extra comma in your statement, just before the WHERE. — andrewsi
– andrewsi, Commented Nov 28, 2013 at 20:52
Use mysqli/pdo and prepared statements, or at least put every SQL token on a new line, improving readability also makes it easier to detect those syntax errors. — Daniel W.
– Daniel W., Commented Nov 28, 2013 at 21:17

Joaquín O · Accepted Answer · 2013-11-28 20:54:56Z

1

$sql = mysql_query("UPDATE [...] bio='$bio2', WHERE agentclient = '$agentclient2'")[...]
                                            ^ this is wrong

answered Nov 28, 2013 at 20:54

Joaquín O

1,4511 gold badge9 silver badges16 bronze badges

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

Comments

NiMeDia · Accepted Answer · 2013-11-28 20:53:28Z

0

The comma before where is wrong, try:

$sql = mysql_query("UPDATE agentclient SET email='$email2', phone='$phone2', Streetaddress='$address2', faxnumber='$faxnumber2', website='$website2', bio='$bio2' WHERE agentclient = '$agentclient2'") or die(mysql_error());

answered Nov 28, 2013 at 20:53

NiMeDia

1,0041 gold badge18 silver badges27 bronze badges

Collectives™ on Stack Overflow

Error in MYSQL syntax with WHERE command

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related