MDanz Posted October 27, 2010 Share Posted October 27, 2010 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 ... line 1 its to do with the code below? what did i do wrong? $query1= mysql_query("UPDATE Users SET \"address 1\"='$address1', \"address 2\"='$address2', city='$city', \"post code\"='$postcode', email='$email', \"contact number\"='$contactnumber' WHERE name='$name'") or die (mysql_error()); Link to comment https://forums.phpfreaks.com/topic/217044-error-in-sql-syntax/ Share on other sites More sharing options...
Pikachu2000 Posted October 27, 2010 Share Posted October 27, 2010 No need for quotes around field names . . . If you feel compelled to enclose them in anything, use backticks ` ` You could also separate the query out of the execution and store it in a variable so you can echo it when you have problems like this. Link to comment https://forums.phpfreaks.com/topic/217044-error-in-sql-syntax/#findComment-1127275 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.