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" <[EMAIL PROTECTED]> 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
> --
>
>
