Editor’s note: In some events, you might like to change or update a field’s data.
You can do it by running a query to update the field in the My SQL database’s table.
Download PHP Driver The topics in this section address how to update data in a database by examining common use cases.
The process of updating or editing a record or row of a table makes use of the trusty mysql_query() function.
Now it is important to note that this query would have updated ALL records that had an age of 21 to the new age of 22.
Basically I am trying to use PHP to update My SQL database and I am testing it with an HTML form.
I intend to use this in an android app so that is where the values will be taken from but currently I am just testing with a HTML form to test the PHP code.
One of the columns in this table is called "Seniority" and it holds an integer value of how many months an employee has worked at your company.
Unfortunately for you, your job is to update these numbers every month.