Hi John - I have come up against this one a number of times, and have found
that the following works pretty nicely - although there may be better ways
out there
- get your records from the db
- loop thru them, using some sort of ID field to print each row in your
table with names something like;
"fieldname|" . $ID
- each field obviously can be edited to whatever, then the whole thing is
submitted
now, when submitted (either back to itself or to another script or whatever)
- loop thru $HTTP_POST/GET_VARS
- when you find, say "title|" . $ID, which might actually appear as
$HTTP_POST_VARS["title|4"] then you can process and update that
entire record, i have copy-pasted a snippet of code below, hope that helps
<?php
[snip other code]
else if ($save) {
foreach ($HTTP_POST_VARS as $name=>$value) {
if (substr($name, 0, 12) == "description|") {
$descriptionID = substr($name, 12);
$SQL = "UPDATE fee_descriptions SET title='$value'
WHERE descriptionID='$descriptionID'";
if ($updated = db_query($SQL))
$msg = urlencode("Fee Descriptions
successfully updated.");
else
$msg = urlencode("There was an error
updating the Fee Descriptions, please try again.");
}
}
}
?>
hope some of those ramblings help
beau
// -----Original Message-----
// From: John Hawkins [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 17 January 2002 4:41 PM
// To: php-db list
// Subject: [PHP-DB] Updating multiple rows from a single form
// submission
//
//
// Hi again!
//
// I have a MySQL table named ratings. It has 5 fields in
// it like this:
// ID, name, deposit, days, hands
//
// The table has 10 rows in it with assorted data in each
// field.
//
// Here is what I would like to to:
//
// 1. Display all 10 rows of data on the page in a table
// with the fields deposit, days and hands in form input
// boxes so the numbers inside can be edited.
// 2. After all the numbers are updated and the user hits
// submit, I would like to have the database updated with
// all the data entered for all rows.
//
// Doing this type of thing for a single record at a time
// is a no brainer. But, when it comes to doing it for
// multiple entries at a single time, I am a bit stumped.
//
// Here are my questions:
// - What do I name the form fields?
// - Upon processing, how do I ensure it writes the
// proper data to the proper record?
//
// Thanks for your help!
//
// John
//
// __________________________________________________
// Do You Yahoo!?
// Send FREE video emails in Yahoo! Mail!
// http://promo.yahoo.com/videomail/
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, e-mail: [EMAIL PROTECTED]
// For additional commands, e-mail: [EMAIL PROTECTED]
// To contact the list administrators, e-mail:
// [EMAIL PROTECTED]
//
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
