Re: Update Multiple Records From Form

On May 28, 2004, at 3:50 AM, Ford, Mike [LSS] wrote:

On 28 May 2004 04:47, Albert Padley wrote:

I feel I'm so close. I have a form with multiple database records with a checkbox to indicate which records to update set up like so: $name = "ed[" . $row['id'] . "]"; <input type=\"checkbox\" name=\"" . $name . "\" value=\"Y\"> Each text input is set up like so: <input type=\text\" name=\"fname[]\" value=\"" . $row['fname'] . "\"> On the processing page I am doing this: foreach($ed as $id=>$val){

      $query = "UPDATE ref_events_reg

SET fname = '$fname' WHERE id = '{$id}'"; I am looping through the correct records, but every field is being updated to "Array". What tweak do I need to make?

I'd make two tweaks, actually. First and most obviously, you're not selecting *which* fname field to pass to your update query, so this needs to be:

    $query = "UPDATE ref_events_reg
             SET     fname = '{$fname[$id]}'
                     WHERE id = '{$id}'";

(By putting just $fname there, you are telling PHP to insert the string representation of the whole array -- and the string representation of any array is, er, exactly "Array"! ;) This change may give you a clue to my other tweak -- I'd explicitly set the indexes of all the fname[] fields to be sure they sync correctly to the related check box, thus:

    <input type=\"checkbox\" name=\"ed[{$row['id']}]\" value=\"Y\">
    <input type=\"text\" name=\"fname[{$row['id']}]\" value=\"{$row['fname']}\">

Cheers! Mike Mike,

Thanks for the tweaks. That solved the problem. I had actually tried something like that, but obviously didn't have all the parts working together at the same time. Thanks again. Albert Padley