Updating Multiple Entries

[cap97]

If I had a page like this:

http://www.livinglegend.org/TEST/test.php?TitleID=2

How would I execute a command to update all of the input variables at the same time? I know how to update entries one at a time, but the same thing doesn't work when I have this setup. It only takes the last issue and applies that one. I guess each row has to somehow be unique but I'm not sure how to do it...

[cgraz]

what i would do is setup your fields so the name is the IssueID and the value is the value.

<input type="text" name="1423" value="4"><br>
<input type="text" name="1424" value="5"><br>

Then you can use a loop to loop through and update your database

foreach($_POST as $IssueID => $value) {
   $query = mysql_query("UPDATE your_table SET field_name='$value' WHERE IssueID = '$IssueID'") or die(mysql_error());
}

Cgraz

[cap97]

Cool, that worked, thanks! Can I ask why it worked though? I get all of it but this little bit:

foreach($_POST as $IssueID => $value)

Why does $IssueID have to be equal to or greater than $value?

[cgraz]

lookup a foreach loop in the php manual. the => is just the syntax. I'll do my best to break down the foreach loop; hopefully it will make sense.

Your form's method is set to post, so you have access to an array variable called $_POST (very important, it's an ARRAY variable, not just a variable).

what a foreach loop does is cycles through the array, and assigns the key a value and the value a value. So in this example:

foreach($_POST as $IssueID => $value) {

means for each part of the array, the key of that array (which is the name in your form for that field) will be put into a variable called $IssueID, the value that that field has will be put into a variable called $value. I specified the variables $IssueID and $value. You could change thos to whatever you want.

foreach($_POST as $key => $value) {

or

foreach($_POST as $animal => $dog) {

etc

then, when you update your database with those values. the $IssueID is the name of your form field, which is the IssueID in the db, and the value is the value you want to update.

Oh and BTW, if you don't want the key, just the value in the foreach loop, you can use

foreach($_POST as $value) {

Hope this made sense.

Cgraz