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