\n";
sqlInsert("employees", $arg2);
$r = sqlSelect("employees", $q);
$r = mysql_fetch_assoc($r['r']);
$_REQUEST['empNo'] = $r['empNo'];
}
else // this is an edit
sqlUpdate("employees", $arg, "empNo = '".$_REQUEST['empNo']."'");
if (!empty($_REQUEST['pNumber'])) // we also have a phone to process
updatePhoneEntry("e", $_REQUEST['empNo'], $_REQUEST['pType'], $_REQUEST['pNumber']);
$_REQUEST['edit'] = $_REQUEST['empNo'];
}
if (!empty($_REQUEST['edit']))
{ $empDat = sqlSelect("employees", "empNo = '".$_REQUEST['edit']."'");
$empDat = mysql_fetch_assoc($empDat['r']);
if (!empty($_REQUEST['pTid']))
{ $phone = sqlSelect("phones", "tid = '".$_REQUEST['pTid']."'");
$phone = mysql_fetch_assoc($phone['r']);
$empDat['pType'] = $phone['pType'];
$empDat['pNumber'] = $phone['pNumber'];
sqlUpdate("phones", "cType = '', pLink = '', pType = '', pNumber = ''", "tid = '".$_REQUEST['pTid']."'");
}
}
echo "
\n"; include 'userList.php'; echo " | \n"; include 'userDat.php'; echo " |