Struktur Organisasi

Hem saya juga butuh mas Rudy...

Haloooooo

coba ini, dapat source dari sebelah:
 
<?php
// Mysqlconnection needs to be started before calling the functions.  Usage is at the end of the file.
 
function retrieveOrgList($parentid=false) {
	$parentid = ($parentid==false)?0:$parentid;
	$query = mysql_query("SELECT org.id, org.company_name, rel.superior, userid, us.firstname, us.surname, us.job_title, us.job_role, us.image FROM organisations org, relationships rel, users us WHERE rel.organisationid = org.id AND rel.userid = us.id AND superior = " . $parentid) or die(mysql_error());
	$numRows = mysql_num_rows($query);
 
	$orgArray = "none";
	if ($numRows > 0) {
		$orgArray=array();
		while ($row = mysql_fetch_assoc($query)) {
			$orgArray[$row['company_name']]['id'] = $row['id'];
			$orgArray[$row['company_name']]['superior'] = $row['superior'];
			$orgArray[$row['company_name']]['userid'] = $row['userid'];
			$orgArray[$row['company_name']]['firstname'] = $row['firstname'];
			$orgArray[$row['company_name']]['surname'] = $row['surname'];
			$orgArray[$row['company_name']]['job_title'] = $row['job_title'];
			$orgArray[$row['company_name']]['job_role'] = $row['job_role'];
			$orgArray[$row['company_name']]['image'] = $row['image'];
			$orgArray[$row['company_name']]['unders'] = retrieveCategoryList($row['userid']);
		}
	}
 
	return $orgArray;
}
 
function displayOrgs($org=false, $charDisp=0) {
	if (!$org) {
		if ($charDisp != 0) {
			$orgs = retrieveOrgList($charDisp);
		}else {
			$orgs = retrieveOrgList();
		}
		foreach ($orgs as $org) {
			displayOrgs($org);
		}
	}else {
		echo str_repeat("_", $charDisp) . $org['firstname'] . "<br />";
		if ($org['unders'] != "none") {
			foreach ($org['unders'] as $value) {
				displayOrgs($value, $charDisp+1);
			}
		}
	}
}
 
displayOrgs(false, 0);
 
echo "<pre>";
// Lets just pull out a set of organizations.
print_r(retrieveOrgList());
 
/*
insert into `users` (`id`, `firstname`, `surname`, `job_title`, `job_role`, `image`) VALUES (4, 'Hassan', 'Noor', 'hassan.noor', 'Manager', 'manager');
insert into `users` (`id`, `firstname`, `surname`, `job_title`, `job_role`, `image`) VALUES (4, 'Noor', 'Hassan', 'noor.hassan', 'Super visor', 'supervisor');
?>