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. 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' 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. 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
Archived
This topic is now archived and is closed to further replies.