[PHP] Multiple Update from one form

[Enda Nagle - Lists]

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
--