1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
<?php
if(isset($_POST["Project"])){
mysql_connect("localhost","root","tulaurapamoncode");
mysql_select_db("database");
$query="UPDATE project p, prgmgr prg, prjmgr prj, busorg b, rdorg ro, customer c, platform pt
SET p.Name=$_POST["ProjectName"],
p.PrgMgrID=$_POST["ProgramManager"],
p.PrjMgrID=$_POST["ProjectManager"],
p.BusOrgID=$_POST["BusOrg"],
p.RDOrgID=$_POST["RDOrg"],
p.CustomerID=$_POST["Customer"],
p.PlatformID=$_POST["Platform"],
p.Type=$_POST["Type"],
p.Archived=$_POST["Archived"]
WHERE p.ProjectID=$_POST["Project"]
DELETE FROM siteprj WHERE ProjectID=$_POST["Project"];
INSERT INTO siteprj
VALUES($_POST["RDSite"], $_POST["Project"]);";
mysql_query($query);
}
?> |
Partager