Multiple Update query

mabans

If I display a list with multiple rows from a MySQL database. How can one achieve the ability to update those mutilple rows at the same time. Using text fields, Drop downs, check boxes, forms etc..

I have an idea how do it when updating 1 record, but when updating more than one in a list style. I would assume it would be 1 form for each section as shown in the diagram below.

Code - Name - Size - Price - Discount - Color

123 - Fish - Large - $150 - $100 - Silver

456 - dog - Large - $500 - $300 - brown

789 - cat - small - $300 - $200 - Black

Let's say I wish to change some of the information on this display change the text entry on "123", the size for "456", and the color for "789". I'm assuming for each one there is a form but the back end for the UPDATE query I don't know. Is it multiple queries or what? Thanks in advance, and I will expand more if needed.

Brendan_Nolan

Make your HTML form field names arrays...

<input type="text" name="code[]" value="1">

And then in PHP...

for ($i = 0; $i < count($_POST["code"]); $i++){
    // Do your database update...
    //$_POST["code"][$i];
}

cmason22

what's the best way to pass the row IDs in this scenario?

mtimdog

pass them as a hidden field, then access them as you would the other rows.