scrubbicus Posted July 18, 2009 Share Posted July 18, 2009 UPDATE SET adtitle = 'titlellll', addesc = '<p>description</p>', area = 'S.F. Bay Area', email = 'scrubbicus@gmail.com', phone = '', youtube = '', showemail = '2', othercontactok = '0', timestamp = NOW(), price = '500' WHERE adid = 28You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET adtitle = 'titlellll', addesc = '<p>description</p>', ' at line 2 So I what does this error mean exactly? At line 2 near SET adtitle I see that and I looked at my code and there are no errors. I started receiving this error when I changed some code in the form itself so maybe I'm not receiving certain values back that I need is what I'm guessing but when I look near the area it tells me all those fields are getting values and have no errors. Quote Link to comment https://forums.phpfreaks.com/topic/166446-solved-mysql-error-cant-tell-where-it-is/ Share on other sites More sharing options...
PFMaBiSmAd Posted July 18, 2009 Share Posted July 18, 2009 There is no table name in the query - UPDATE your_table SET ... Quote Link to comment https://forums.phpfreaks.com/topic/166446-solved-mysql-error-cant-tell-where-it-is/#findComment-877734 Share on other sites More sharing options...
scrubbicus Posted July 21, 2009 Author Share Posted July 21, 2009 ha! thanks. Quote Link to comment https://forums.phpfreaks.com/topic/166446-solved-mysql-error-cant-tell-where-it-is/#findComment-879213 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.