jdubwelch Posted December 19, 2006 Share Posted December 19, 2006 I'm getting this error:[quote]#1064 - You have an error in your SQL syntax near ''G8' = 'Middle Tennessee', 'G9' = 'Florida State', 'G10' = 'Oklahoma State', 'G1' at line 1 [/quote]this is my query:[code]UPDATE `picks` SET 'G8' = 'Middle Tennessee','G9' = 'Florida State','G10' = 'Oklahoma State','G11' = 'Rutgers','G12' = 'Texas A&M','G13' = 'Clemson','G14' = 'Oregon State','G15' = 'Houston','G16' = 'Texas Tech','G17' = 'Purdue','G18' = 'Navy','G19' = 'Texas','G20' = 'Georgia','G21' = 'Miami (Fla.)','G22' = 'Tennessee','G23' = 'Auburn','G24' = 'Arkansas','G25' = 'Georgia Tech','G26' = 'USC','G27' = 'Boise State','G28' = 'Louisville','G29' = 'Notre Dame','G30' = 'Western Michigan','G31' = 'Ohio','G32' = 'Florida','tiebreaker' = '15','otRose' = '10','otFiesta' = '30','otOrange' = '40','otSugar' = '40','otBCS' = '50' WHERE 'user_id' = '9' LIMIT 1[/code] Link to comment https://forums.phpfreaks.com/topic/31208-solved-error-in-sql-syntax-but-i-dont-see-it/ Share on other sites More sharing options...
btherl Posted December 19, 2006 Share Posted December 19, 2006 Try [code=php:0]`G8` = 'Middle Tennessee'[/code] instead of [code=php:0]'G8' = 'Middle Tennessee'[/code] Link to comment https://forums.phpfreaks.com/topic/31208-solved-error-in-sql-syntax-but-i-dont-see-it/#findComment-144295 Share on other sites More sharing options...
jdubwelch Posted December 19, 2006 Author Share Posted December 19, 2006 you got it!!! thanks Link to comment https://forums.phpfreaks.com/topic/31208-solved-error-in-sql-syntax-but-i-dont-see-it/#findComment-144303 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.