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()); Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/217044-error-in-sql-syntax/#findComment-1127275 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.