ISO_job_base_process_interestedpartys
 
 id	int(11)			No		auto_increment	 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	processid	int(11)			No			 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	interestedparty	int(11)			No			 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	addedby	int(11)			No			 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	addedon
	
	
ISO_InterestedParties
id	int(11)			No		auto_increment	 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	description	varchar(128)	latin1_swedish_ci		No			 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	addedby	int(11)			No			 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	addedon	int(11)			No			 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	scope	longtex
	
	
ISO_InterestedParties_risks
	id	int(11)			No		auto_increment	 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	interestedpartyid	int(11)			No			 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	description	varchar(250)	latin1_swedish_ci		No			 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	addedby	int(11)			No			 Browse distinct values	 Change	 Drop	 Primary	 Unique	 Index	Fulltext
	addedon
	

	
$s="SELECT * FROM ISO_InterestedParties_risk_process";
$result=getquery($s);
while ($row=mysql_fetch_array($result))
        {
        $riskid=$row[riskid];
        $processid=$row[processid];
        $link=md5($riskid."ASA".$processid);
        $processlist[$link]=$row[addedby];
        }