Re: Bulk table updates

Use a SELECT query to get the values (SELECT * FROM table) and a table that has form input fields in the cells. The values for the form fields would be based on the array you get from the SELECT query. The form could be something like <form action="<?=$PHP_SELF ?>" method="post">. In the script, before the body, you would have an if statement to check whether the submit button for the form is set; if it is set, it will run an INSERT INTO query: if (isset ($submit)) { $query = "INSERT INTO . . . "; $query_result = @mysql_query ($query); } If the form is submitted, then the values in all the form fields (including any changes) will go into the database. If it's not submitted, the current values will be displayed in the tabled-embedded form. Actually, I think if the form is submitted, it will redisplay with the new values as defaults. Hopefully this will work, or lead you in the right direction. -----Original Message----- From: Robert Sossomon <robert@gcnorris.com> Sent: Jun 3, 2004 6:23 PM To: php-general@lists.php.net Subject: [PHP] Bulk table updates I am looking for a tutorial or a already created class or file that I can use to learn how to create a form that is populated from a database table that can be edited in every row and column and takes only 1 SAVE button to upload all the changes. Thanks, Robert -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php