Re: update more "same" fields at the same time

At 14:29 15-1-03, you wrote:

not with the same data You can put your data and the primary keys in arrays and exec a loop but the data[0] must be the data for the id[0], data[1] must be the data for id[1] etc. The loop should be something like this: for (int $i=0; $i<=total_records_select_returned -1; $i++)

        update table set field1='$data[$i]' where id=$id[$i];

I 'm not sure for the syntax but the idea is correct.

That would work good and is shorter than what i did (and accidently mailed to myself in stead of to this list): You split the record ID and value in two form elements while I lump the fieldname with the recordID into the form element name.

I have table with six records in it. I can use "while" to display them all, but in form. Is there any way I can edit all six records, and update them all with one submit.

The way i understand the question is, you have several records (or rows) in one table that you want to edit on the same page.

One of the many ways to do it: When writing the form, number the fieldnames with the ID's of the items. Separate name and ID with a clear character like '__'

    <input type="text" name="field__531">
    <input type="text" name="field__532">
    <input type="text" name="field__533">

So to make this do something like

1. make a query to select the items, select the values you want to show as well as the record's ID field, from now I will call that $recordID. Echo a <form method="POST" action="whatever.php"> tag 2. Loop through the query result with your favourite loop structure and in the loop echo each record somehow like this: echo ' <input type="text" name="'.fieldname__$recordID.'" value='.$recordfield.'>';

In the receiving page, split the name again. Then build a query for every record.

With fieldname 'fieldname':

while (list ($key, $val) = each ($_POST))                       //walk through all form results, key is form_element_name
                                                                //and value is value.
      {if (! strpos($key,'fieldname')===false)                  //only with variables starting with the fieldname
          { $keybits=explode('__',$key);$recordID=$keybits[1];  //split the recordID out of the name of the variable

           $query="UPDATE mytable SET fieldname='.$value.'   WHERE recordID=$recordID";
        mysql_query($query) or die('Problem updating data );
          }
       }