Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › MySQLi update record fails to update

MySQLi update record fails to update

Thread began 12/31/2014 9:01 am by malcolm230194 | Last modified 1/06/2015 3:02 am by malcolm230194 | 620 views | 3 replies |

12/31/2014 9:01 am | #1 malcolm230194

MySQLi update record fails to update

I am using update record to change an order status value to filter orders by the stage that they have reached in production.

The status field is simply set to an integer value but the update behaviour doesn't save the new value. The behaviour is set to trigger on current page submit. Suggestions please.

12/31/2014 3:12 pm | #2 Ray BorduinWebAssist

Current page submit checks the referrer in the header. Sometimes that can be blocked by security settings and may cause the trigger to not fire.

Try a button press trigger instead and see if that works.

Did this help? Tips are appreciated...

1/06/2015 2:54 am | #3 malcolm230194

I've recreated the page with DataAssist and it works fine. What's going on with MySQLi?

1/06/2015 3:02 am | #4 malcolm230194

Sorry Ray I hadn't refreshed the page and didn't see your reply. I changed it to button press and it works.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.