JREAM Posted October 13, 2009 Share Posted October 13, 2009 Im trying to make this so that it will either INSERT or UPDATE Based upon IF assign_bot and assign_user exist in one row, Then UPDATE, If it's false, then INSERT. INSERT INTO tmp_battles SET `assign_bot` = '$bot[id]', `assign_user` = '{$sess->get('userID')}', `battle_hp` = '$bot[hp]' ON DUPLICATE KEY UPDATE `battle_hp` = '$bot[hp]' I don't have a real foreign key because I use MyISAM not InnoDB, therefor I don't know If the duplicate key is doing anything here. Link to comment https://forums.phpfreaks.com/topic/177583-trying-to-figure-this-out-on-duplicate-key/ Share on other sites More sharing options...
Maq Posted October 13, 2009 Share Posted October 13, 2009 REPLACE INTO seems to be what you're looking for. Link to comment https://forums.phpfreaks.com/topic/177583-trying-to-figure-this-out-on-duplicate-key/#findComment-936348 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.