<?php
$now = date("m/j/y h:i:s",time());
include "connect.php";
$ROUTER = $_POST['ROUTER'];
$PORT = $_POST['PORT'];
$LOCATION_SERVED = $_POST['LOCATION_SERVED'];
$SUBNET_TYPE = $_POST['SUBNET_TYPE'];
$LAB_DESC = $_POST['LAB_DESC'];
$OWNER = $_POST['OWNER'];
$SUBNET = $_POST['SUBNET'];
$now = date("j/m/y h:i:s",time());
$i=0;
$ii=count($SUBNET);
for($i=0;$i<$ii;$i++){
if ($OWNER[$i]!='999999') {
$stmt = "update subnets set ROUTER = '$ROUTER[$i]', PORT_NUMBER = '$PORT[$i]', LOCATION_SERVED = '$LOCATION_SERVED[$i]', SUBNET_TYPE = '$SUBNET_TYPE[$i]', UNITS_SERVED = '$LAB_DESC[$i]', CONTACT = '$OWNER[$i]' where SUBNET = '$SUBNET[$i]';";
} else
{
$stmt = "update subnets set ROUTER = '$ROUTER[$i]', PORT_NUMBER = '$PORT[$i]', LOCATION_SERVED = '$LOCATION_SERVED[$i]', SUBNET_TYPE = '$SUBNET_TYPE[$i]', UNITS_SERVED = '$LAB_DESC[$i]' where SUBNET = '$SUBNET[$i]';";
}
$sth = ibase_query ($dbh,$stmt);
echo $SUBNET[$i] . '<BR>';
}
ibase_close($dbh);
?>