3raser Posted March 18, 2012 Share Posted March 18, 2012 When I move threads on my forum, I want there to be a old thread in the section it was moved from saying "Moved: new link". To do this, I'm inserting a new thread in the database with the value moved equal to the new location, so when threads are being displayed users can see the thread in the new section. Is there a quick function in MySQL that will allow me to create a duplicate row in MySQL, and then just run a quick update statement? I don't want to have to insert a whole new thread like this (unless it's the only way): //insert new thread mysql_query("INSERT INTO `threads` VALUES (null, '$id','$title', '$content', '". getUsername() ."', NOW(), '". qfc() ."', NOW(), '". getUsername() ."', '','{$_SERVER['REMOTE_ADDR']}', '0', '0', '0', '', '0')"); Quote Link to comment https://forums.phpfreaks.com/topic/259192-best-way-of-making-a-duplicate-row-in-mysql/ Share on other sites More sharing options...
trq Posted March 18, 2012 Share Posted March 18, 2012 No such functionality in MySql. Quote Link to comment https://forums.phpfreaks.com/topic/259192-best-way-of-making-a-duplicate-row-in-mysql/#findComment-1328700 Share on other sites More sharing options...
3raser Posted March 18, 2012 Author Share Posted March 18, 2012 Gah...... Quote Link to comment https://forums.phpfreaks.com/topic/259192-best-way-of-making-a-duplicate-row-in-mysql/#findComment-1328701 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.