jesushax Posted March 30, 2009 Share Posted March 30, 2009 hi all i have an error below can anyone spot it? the debug is first UPDATE tblDirectory2 SET (`Sect2_1`='1,000,000,000', `Sect2_2`='1,000,000,000', `Sect2_3`='1,000,000,000', `Sect2_4`='1,000,000,000', `Sect2_5`='1,000,000,000', `Sect3_1`='More than 1.5m', `Sect3_2`='1', `Sect3_3`='More than 1.5m', `Sect3_4`='More than 1.5m', `Sect3_5`='CIS 6', `Sect4_1`='Genius foundations, creator life', `Sect4_2`='website gurus', `Sect4_3`='sasuages certified' WHERE `CompanyID`='4') 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 '(`Sect2_1`='1,000,000,000', `Sect2_2`='1,000,000,000', `Sect2_3`='1,000,000,000'' at line 1 Link to comment https://forums.phpfreaks.com/topic/151715-solved-sql-error-i-cant-spot-it-can-you-help/ Share on other sites More sharing options...
Ayon Posted March 30, 2009 Share Posted March 30, 2009 try removing the ()'s Link to comment https://forums.phpfreaks.com/topic/151715-solved-sql-error-i-cant-spot-it-can-you-help/#findComment-796713 Share on other sites More sharing options...
jesushax Posted March 30, 2009 Author Share Posted March 30, 2009 sorted, silly me, should of recognised that!! :| Thankyou though Link to comment https://forums.phpfreaks.com/topic/151715-solved-sql-error-i-cant-spot-it-can-you-help/#findComment-796714 Share on other sites More sharing options...
Ayon Posted March 30, 2009 Share Posted March 30, 2009 hehe np... tiny things like that is easily missed when you've looked at the code for a while i know i do that ALOT xD Link to comment https://forums.phpfreaks.com/topic/151715-solved-sql-error-i-cant-spot-it-can-you-help/#findComment-796715 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.