Re: Nested database loops and completing an unordered list....

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


[snip]…stuff…[/snip]

I am getting close, but I am also getting frustrated. I probably need to walk away for a bit.

I have an array of tiers….

Array
(
    [0] => TIER1DATA
    [1] => TIER2DATA
    [2] => TIER3DATA
    [3] => BUSTIER1DATA
    [4] => BUSTIER2DATA
    [5] => BUSTIER3DATA
    [6] => BUSTIER4DATA
)
Each of the tiers which represent parents in children in pairs. TIER1DATA is the parent of TIER2DATA, etc. representing 7 columns of data. Here is my code so far - any insight would be valuable and extremely appreciated by me.

function display_children($i, $child) {
	global $dbc;
	global $tierArray;
	echo $i."<br />";
	/* retrieve children of parent */
	$get = "SELECT DISTINCT `". $tierArray[$i] ."` FROM `POSITION_SETUP` ";
	$get .= "WHERE `COMPANY_ID` = '3' ";
	if($i > 0) {
		$get .= "AND `" . $tierArray[$i - 1] . "` = '" . $child . "' ";
	}
	echo $get."<br />";
	if(!($result = mysql_query($get, $dbc))) {
		echo mysql_errno() . "\t" . mysql_error() . "\n";
		exit();
	}
	
	while($row = mysql_fetch_array($result)) {
		
		/* indent and display the title of this child */
		echo str_repeat('&nbsp;',$i).$row[$tierArray[$i]]."<br />\n";
		
		/* get the children's children */
		display_children($i + 1, $row[$tierArray[$i]]);
	}
}

It does produce the right query for only the first child in each case, I cannot get it to go deeper. I have just been looking at it for too long. TVMIA!

[PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [Find Someone]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux