Padgoi Posted December 29, 2008 Share Posted December 29, 2008 Hi, I have a forum ID 397 and I want to change the state of all topics in that forum from Closed to Open. What SQL query would I have to run to do this? If anyone could help, I'd really appreciate it. Thanks in advance. The table is ibf_topics State field is state forum field is forum_id Quote Link to comment https://forums.phpfreaks.com/topic/138769-solved-sql-query-help/ Share on other sites More sharing options...
Maq Posted December 29, 2008 Share Posted December 29, 2008 Please make an attempt next time. UPDATE ibf_topics SET state = 'Open' WHERE forum_id = 397 Quote Link to comment https://forums.phpfreaks.com/topic/138769-solved-sql-query-help/#findComment-725570 Share on other sites More sharing options...
Padgoi Posted December 29, 2008 Author Share Posted December 29, 2008 Thank you for the help. I'll make an attempt next time, though it won't be pretty. Quote Link to comment https://forums.phpfreaks.com/topic/138769-solved-sql-query-help/#findComment-725582 Share on other sites More sharing options...
Maq Posted December 29, 2008 Share Posted December 29, 2008 Thank you for the help. I'll make an attempt next time, though it won't be pretty. Doesn't matter, now you're just going to copy and paste what I wrote and really not learn much. I used to do the same thing until I got a web development position for my internship and had to write my own queries everyday. :-\ Trust me, failing miserably is much better for you than CnP'ing. Quote Link to comment https://forums.phpfreaks.com/topic/138769-solved-sql-query-help/#findComment-725590 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.