scrubbicus Posted July 18, 2009 Share Posted July 18, 2009 UPDATE SET adtitle = 'titlellll', addesc = '<p>description</p>', area = 'S.F. Bay Area', email = '[email protected]', 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. 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 ... 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. 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
Archived
This topic is now archived and is closed to further replies.