Create buttton to change and update one field in the database

Hello All,

I need to create a buttton to change and update one field in the database inside a form (instead of delete i need to add a trash field with 1).
I’m a scripcase beginner and also programming.

Thanks for help.

Hi
Create a new button in the form with type PHP
In the code:
$update_sql=“your update sentence”;
sc_exec_sql($update_sql);

That’s all.

Thanks, will try. need to understand how to easy define the “your update sentence”

UPDATE table
SET field1=‘value1’, field2=‘value2’
WHERE fieldx=‘valuex’ AND… (in case the condition has more than one field.

MySQL UPDATE Statement

thanks for help. works

🚀 Scriptcase 9.12 is now available! Check out the new features here 👉🚀 Next Monday (02/24), Scriptcase 9.12 will be released! Check out the new features before anyone else 👉