Re: Multiple Update from one form

At 07:56 PM 5/18/2004, Enda Nagle - Lists wrote:

Its OK guys, Got something else myself. Here¹s the solution... Any suggestions appreciated... ///////////////////////////// // UPDATE PART ///////////////////////////// $i=1; //while ($ordersinfo[$i]) while ($i < $total) { $session = $ordersinfo[$i][session]; $tracking = $ordersinfo[$i][tracking]; $kb_ship = $ordersinfo[$i][kb_ship]; $update = mysql_query("UPDATE products_orders SET tracking='$tracking', kb_ship='$kb_ship' WHERE session='$session'") or die (mysql_error()); $i++; } ///////////////////////////// // MAIN PART ///////////////////////////// ... <td align=\"default\" width=\"100\"><input type=text name=\"ordersinfo[$i][tracking]\" value=\"" . $roworders[tracking] . "\" size=25></td> ... Regards Enda -- On 18/05/2004 23:20, "Enda Nagle - Lists" <lists@nightsol.net> wrote: Hi I have a current application where I am listing a table of order details, where a fulfillment company can enter the tracking number and the cost of the shipment. At present, I have up to 40 orders displayed, and when they click on the Œupdate¹ button, the code executes as

    if ((isset($tracking1)) && (isset($kb_ship1))){
      $update=mysql_query("UPDATE orders SET
tracking='$tracking1',kb_ship='$kb_ship1' WHERE order_ref = '$ref1'",$link);
    }

And this continues as tracking 2... tracking40. I would like to implement something like foreach ($_POST["ref"]){

      $update=mysql_query("UPDATE orders SET

tracking='$tracking',kb_ship='$kb_ship' WHERE order_ref = '$ref'",$link); } Instead, but I¹m not so sure how I can do this, given that form variables cannot be named the same etc. I¹m sure that there¹s a better way that the way in which I¹m doing it at the moment, so any input would be appreciated. Thanks Enda --

Enda, This is close to your situation, but I only needed a one dimensional array for a bulk delete. So the form part has this line:

        print( '<input type="checkbox" name=chkdelete[] value="' . $myrow['sub_key'] . '">');
There's no need for a subscript in the form - there are presently a potential of 963 elements in this array. When we check for bulk delete it's never contiguous, we skip down the list, so array is v. sparse.

And the processing part uses this loop:

        foreach ($chkdelete as $value){
                $sql = "delete from subscriber where sub_key = '$value'";
                $result = mysql_query($sql);
        }

This way I'm in no danger of hitting a missing subscript as I might if I used $chkdelete[ $i ], incrementing $i HTH - Miles