Lexicon Posted December 23, 2010 Share Posted December 23, 2010 I'm using this to update my database at multiple columns, and nothing is working. Tried adding and removing ' ' around entries and still can't get it. UPDATE tablehouse SET 'kid1' = 'girl', SET 'kid2' = 'girl', SET 'kid3' = 'boy' WHERE entry='house1' No clue whats going on here. Thanks for any help. Quote Link to comment https://forums.phpfreaks.com/topic/222539-no-idea-why-this-query-is-not-working-to-update-my-database-any-help/ Share on other sites More sharing options...
mikosiko Posted December 24, 2010 Share Posted December 24, 2010 don't use quotes to surround your field names also... use SET only one time SET kid1 = 'girl', kid2 = 'girl', kid3 = 'boy' Quote Link to comment https://forums.phpfreaks.com/topic/222539-no-idea-why-this-query-is-not-working-to-update-my-database-any-help/#findComment-1150970 Share on other sites More sharing options...
Lexicon Posted December 24, 2010 Author Share Posted December 24, 2010 WOW. 45 minutes of playing around with it wasted on such a simple task. Thanks for the help. Quote Link to comment https://forums.phpfreaks.com/topic/222539-no-idea-why-this-query-is-not-working-to-update-my-database-any-help/#findComment-1151019 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.