benjam Posted October 13, 2006 Share Posted October 13, 2006 I have a chess script and I would like to add the total wins, draws, and losses collected in one instance (table) to the wins, draws, and losses collected in another instance (table).For instance:table 1 is like:playerp_idp_usernamep_winsp_drawsP_lossesand table 2 is like:wc2_playerp_idp_usernamep_winsP_drawsp_lossesI would like to add the wins from `player` into `wc2_player`, but only if the value for p_username is the same.Can I do this in one query? Both tables are in the same DB. Link to comment https://forums.phpfreaks.com/topic/23897-combining-values-from-two-separate-tables/ Share on other sites More sharing options...
fenway Posted October 13, 2006 Share Posted October 13, 2006 Try the following (UNTESTED, so back up your DB!)[code]UPDATE wc2_player INNER JOIN player USING p_username SET wc2_player.p_wins += player.p_wins[/code] Link to comment https://forums.phpfreaks.com/topic/23897-combining-values-from-two-separate-tables/#findComment-108650 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.