Ok, not quite got it working. I've added a MySQL field PublishedStatus as Int (11) and added a second submit button. I'm just not quite sure what I need to set in the Insert Record behaviour to give it a value of 1 (or 0). Please see attached file.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.