Padgoi Posted October 30, 2007 Share Posted October 30, 2007 Ok, so I kinda had a problem with my boards. Right now, all of the topics in the sql dbase are in forum_id 369. I need to move them ALL to forum_id 3. I need an sql function to help me so I don't have to manually move 9,000 topics to the correct forum_id. Please any help? The table is ibf_topics and the field I need to change is forum_id for the topics. Quote Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/ Share on other sites More sharing options...
iceblox Posted October 30, 2007 Share Posted October 30, 2007 I had to do the same before. I think its UPDATE you need Quote Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/#findComment-381420 Share on other sites More sharing options...
MadTechie Posted October 30, 2007 Share Posted October 30, 2007 you mean like this UPDATE ibf_topics SET forum_id=3 WHERE forum_id=369 WARNING BACKUP FIRST SQL DUMP Quote Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/#findComment-381421 Share on other sites More sharing options...
Padgoi Posted October 30, 2007 Author Share Posted October 30, 2007 Yes, but I need the exact function. Quote Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/#findComment-381422 Share on other sites More sharing options...
MadTechie Posted October 30, 2007 Share Posted October 30, 2007 mysql_query Okay.. that table is from IPB.. so you can use the SQL toolbox (i think its called that) to execute that statement.. But i do think you can also do a mass move form the admin control panel as well Quote Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/#findComment-381423 Share on other sites More sharing options...
MadTechie Posted October 30, 2007 Share Posted October 30, 2007 Yep.. admin CP, (admin tab) SQL toolbox then at the bottom Run a Query Manual Query (Advanced Users Only) But you can mass move from the forum as well, (tick the top most box) then action move Quote Link to comment https://forums.phpfreaks.com/topic/75401-sql-quick-question/#findComment-381425 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.