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