MySQL Database MySQL Connect MySQL Create DB MySQL Create Table MySQL Insert Data MySQL Get Last ID MySQL Insert Multiple MySQL Prepared MySQL Select Data MySQL Delete Data MySQL Update Data MySQL Limit Data PHP - XML PHP XML Parsers PHP SimpleXML Parser PHP SimpleXML - Get PHP XML Expat PHP XML DOM PHP - AJAX Updating MySQL data table with php. Ask Question up vote-2 down vote favorite. I'm working on a simple project for a client, but I cannot get past editing and updating data in mysql. Here's my code that is passed from the edit submission form: updateinfo.php Updating Data into MySQL Database Using PHP - A simple and short PHP tutorial and complete reference manual for all built-in PHP functions. This tutorial is designed for beginners to advanced developers. Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site. PHP MySQL UPDATE Query. In this tutorial you'll learn how to update the records in a MySQL table using PHP. Updating Database Table Data. The UPDATE statement is used to change or modify the existing records in a database table. This statement is typically used in conjugation with the WHERE clause to apply the changes to only those records that matches specific criteria. Data storing in to database enables us to keep the information safe and secure, but what if we wish to update it. Here we are with the proper solution i.e. Update data in database using PHP. In this blog post we will show you how to update previously stored information in database using PHP. In this lesson I modified the HTML table that displayed my records from the database in Lesson 37 and placed the data into text boxes to allow for editing of the text. In this tutorial, we create 3 PHP files for testing our code. 1. list_records.php 2. update.php 3. update_ac.php Steps 1. Create table "test_mysql" in database "test" Updating Data Using a PHP Script You can use the SQL UPDATE command with or without the WHERE CLAUSE into the PHP function – mysql_query() . This function will execute the SQL command in a similar way it is executed at the mysql> prompt. In the third script, place the following lines right after the mysql_select_db (near line 90). This will print out the values in $_POST - that is the information being transferred to the third script.