Who knows how to duplicate a task?

[pfchin]

I want to duplicate a task but within the task there could be more than one sub-task and within the sub-tasks it can contain more than one detail and inside one detail may have more than one sub-detail.
Duplicated task should have a new ID(auto-increment data type) different from the old task and also sub-tasks, details & sub-details.

All of them are links togethers with the ID. One unique id for task eg. PID, one id for sub-task eg. PFCID, one id for detail eg. PFID, and one id for sub-detail eg. PPID.

This is the senario i try to solve but i duplicated all the sub-details into one detail and all the details were duplicated into one sub-tasks.

So can anyone understand and helps me to think about it??? It is in hurry.... thanks a lot....

[bdbush]

Sounds like you just need to use nested loops. example:

for($i = 0; $i < $foo; $i++)
{
$task = $i;
for($j = 0; $j < $bar; $j++😉
{
$subtask = $j; //while $task is still $i
for($k = 0; $k < blah; $k++)
{
$detail = $k; //$subtask is $j and $task is $i
}
}
}

That can go on forever. You could also build this into a self-recursing function.

--brian

[pfchin]

I already used the nested for loop as you showed me but the details are apprearing inside all the TASK that it shouldn't and also the sub-details do.

Here is my Problems codes:

$sql="SELECT * FROM partmst WHERE PCode='$OldPCode'";
if(!($getsql=mysql_query($sql))) choke(FILE,LINE,mysql_error());
$partrow=mysql_fetch_array($getsql);

$validate="SELECT partmst.PCode from partmst WHERE PCode='$NewPCode'";
if(!($value=mysql_query($validate))) choke(__FILE__,__LINE__,mysql_error());
if (mysql_num_rows($value)){
	$compare=mysql_result($value,0,0);
}
if (!($compare)) {

$query="INSERT INTO partmst (PID,PCode,PNo,PName,PType,PStatus) VALUES ".
  	 "('','$NewPCode','$partrow[PNo]','$partrow[PName]','$partrow[PType]',".
 	 "'$partrow[PStatus]')";
if(!($result=mysql_query($query))) choke(__FILE__,__LINE__,mysql_error());

switch ($inspection_id) {

	case 'PFCID':
			/*********************************
			 **		MASTER		**
			 *********************************/
			$fstquery="SELECT pfcmst.*, partmst.PID FROM pfcmst,partmst WHERE".
			     " partmst.PID=pfcmst.PID AND partmst.PCode='$OldPCode'";
			if (!($fstresult=mysql_query($fstquery)))
				choke(__FILE__,__LINE__,mysql_error());
			$mst_row=@mysql_num_rows($fstresult);

			if (!($mst_row == 0)) {
				for ($i=1; $i<=$mst_row; $i++) {
				if (mysql_data_seek($fstresult, $i-1)) {

					//************ INSERT MASTER ****************//

					$part="SELECT * FROM partmst WHERE PCode='$NewPCode'";
					if (!($presult=mysql_query($part)))
						choke(__FILE__,__LINE__,mysql_error());
					$prow=mysql_fetch_array($presult);

					//****** RETRIEVING OLD MASTER RECORD ******//
					$fstrow=mysql_fetch_array($fstresult);

					$query = "INSERT INTO pfcmst (PID, DNo, CID, Rev, Effective,".
						 " Initiator, InitiatorDate) VALUES ('$prow[PID]',".
						 " '$fstrow[DNo]', '$fstrow[CID]', '$fstrow[Rev]',".
						 " '$fstrow[Effective]','$fstrow[Initiator]',".
						 " '$fstrow[InitiatorDate]')";
					if(!($result = mysql_query($query))) 
						choke(__FILE__, __LINE__, mysql_error());

					} // if fstresult
					} // for mst_row
					} // end if (mst_row=0)


					//******** DETAIL *********//
					$secquery="SELECT pfcdetail.*,pfcmst.PFCID,pfcmst.PID,partmst.PID FROM".
				 		  " pfcdetail,pfcmst,partmst WHERE partmst.PID=pfcmst.PID AND".
				  		  " pfcmst.PFCID=pfcdetail.PFCID AND".
						  " partmst.PCode='$OldPCode'";
					if (!($secresult=mysql_query($secquery)))
						choke(__FILE__,__LINE__,mysql_error());
					$dtl_row=@mysql_num_rows($secresult);

					if (!($dtl_row==0)) {
						for ($ii=1; $ii<=$dtl_row; $ii++) {
						if (mysql_data_seek($secresult, $ii-1)) {

						//************ INSERT DETAIL ****************//

						$getPFCID="SELECT pfcmst.*,partmst.PID FROM partmst,pfcmst WHERE".
							" partmst.PID=pfcmst.PID AND partmst.PCode = '$NewPCode'";
						if (!($PFCIDresult = mysql_query($getPFCID)))
							choke(__FILE__,__LINE__,mysql_error());
						$mstrow=mysql_fetch_array($PFCIDresult);

						//************ RETRIEVING OLD DETAIL RECORD ***********//
						$OldDetail = mysql_fetch_array($secresult);

						$query = "INSERT INTO pfcdetail (PFCID, ProcessNo, Name, Machine,".
							 " PControl, PBy, PSup, InsType,Item,Spec,Method,Ins, InsSup,".
							 " Remarks) VALUES ('$mstrow[PFCID]', '$OldDetail[ProcessNo]',".
							 " '$OldDetail[Name]','$OldDetail[Machine]','$OldDetail[PControl]',".
							 " '$OldDetail[PBy]','$OldDetail[PSup]','$OldDetail[InsType]',".
						 	 " '$OldDetail[Item]','$OldDetail[Spec]','$OldDetail[Method]',".
							 " '$OldDetail[Ins]','$OldDetail[InsSup]','$$OldDetail[Remarks]')";
						if ( !($tmpResult = mysql_query($query)) ) 
							choke(__FILE__, __LINE__, mysql_error());


						} // if secresult
						} // for dtl_row
						} // end if (dtl_row=0)



						//******** PROCESS *********//

						$thdquery="SELECT pfcprocess.*,pfcdetail.PFID,pfcdetail.PFCID,".
							   " pfcmst.PFCID,pfcmst.PID,partmst.PID FROM pfcprocess,pfcdetail,".
							   " pfcmst,partmst WHERE pfcprocess.PFID=pfcdetail.PFID AND".
							   " pfcdetail.PFCID=pfcmst.PFCID AND pfcmst.PID=partmst.PID AND".
							   " partmst.PCode='$OldPCode'";
						if (!($thdresult=mysql_query($thdquery)))
							choke(__FILE__,__LINE__,mysql_error());
						$pro_row=@mysql_num_rows($thdresult);

						if (!($pro_row==0)) {
							for ($iii=1; $iii<=$pro_row; $iii++) {
							if (mysql_data_seek($thdresult, $iii-1)) {


							//************ INSERT PROCESS ************//
							$getPFID="SELECT pfcdetail.*,pfcmst.PFCID,partmst.PID FROM partmst,pfcmst,".
								" pfcdetail WHERE pfcdetail.PFCID=pfcmst.PFCID AND ".
								" partmst.PID=pfcmst.PID AND partmst.PCode = '$NewPCode'";
							if (!($PFIDresult=mysql_query($getPFID))) 
								choke(__FILE__,__LINE__,mysql_error());
							$dtlrow=mysql_fetch_array($PFIDresult);

							//************* RETRIEVING OLD PROCESS ************// 
							$OldProcess = mysql_fetch_array($thdresult);

							$proquery = "INSERT INTO pfcprocess (PFID, Process) values".
								 " ('$dtlrow[PFID]', '$OldProcess[Process]')";
							if ( !($proresult = mysql_query($proquery)) ) 
								choke(__FILE__, __LINE__, mysql_error() );

							} // if thdresult
							} // for pro_row
							} // end if (pro_row=0)




			break;