Update mutiple records in 1 form

Update your multiple data records in 1 submit form. When you have a list and need to update them in one click.

This tutorial require 2 files and 1 table of mySQL database.

1. form.php, this file shows data records in an update form.
2. update.php, this file is the updater.
3. Database "tutorial" and table "name_list" with 2 fields: id(auto_increment), name(varchar, 50) and put some records about 20 - 30 records into this table. (directly by phpMyAdmin)

Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/k/k/r/kkr152/html/phpfreecode/Update_mutiple_records_in_1_form.htm on line 166 Warning: mysql_select_db() [<a href='function.mysql-select-db'>function.mysql-select-db</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/k/k/r/kkr152/html/phpfreecode/Update_mutiple_records_in_1_form.htm on line 167 Warning: mysql_select_db() [<a href='function.mysql-select-db'>function.mysql-select-db</a>]: A link to the server could not be established in /home/content/k/k/r/kkr152/html/phpfreecode/Update_mutiple_records_in_1_form.htm on line 167 Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/k/k/r/kkr152/html/phpfreecode/Update_mutiple_records_in_1_form.htm on line 170 Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in /home/content/k/k/r/kkr152/html/phpfreecode/Update_mutiple_records_in_1_form.htm on line 170 <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <form id="form1" name="form1" method="post" action="update.php"> <table border="1" cellpadding="3" cellspacing="0"> <tr> <td align="center" bgcolor="#FFCC00">ID</td> <td align="center" bgcolor="#FFCC00">Name</td> </tr> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/k/k/r/kkr152/html/phpfreecode/Update_mutiple_records_in_1_form.htm on line 187 </table> <input type="submit" name="Submit" value="Update" /> </form> </body> </html> /////// create Update.php <a target="_blank" href="http://www.phpfreecode.com/">PHP Free Code</a>

Update Mutiple Records in 1 Form Next Code