It's not very clear what you are trying to do. From what i understand from your mail, i think a recursive call to select_names would be the ideal solution. In these scenario you call select_names() once and from within the function you call select_name() again for the each of the matches on the first level.
You should be aware of the obvious drawback of recursive calls: memory consumption. If your tree strecthes to infinity as you feel it migh, you will get a stack overflow. :-)
Peter Sharpe wrote:
I have a database full of names. each name could be linked to any number of sub-names, each sub-name could be linked to any number of sub-sub-names, to infinity (unlikely but possible).
I need to iterate through this nest of names starting with a main name; lets call the main name Peter. Peter could have John, Tim & Mike working for him. Tim could have Greg working for him.
function select_names($current_top_name){ global $dbh;
$sql = " SELECT name_id_fk FROM name_relation WHERE top_name_id_fk = '".$current_top_name."' "; $rs = pg_query($dbh, $sql);
if(($num_rows = pg_num_rows($rs)) > 0){
for($i=0;$i<$num_rows;$i++){ $row = pg_fetch_row($rs, $i, PGSQL_ASSOC); $associated_names[] = $row['name_id_fk']; }
pg_free_result($rs);
} // end if(($num_rows = pg_num_rows($rs)) > 0)
return $associated_names;
} // end function select_names()
$current_top_name = 'Peter';
while(!$stop){
$assoc_names = select_names($current_top_name);
foreach($assoc_names as $key => $val){ print($val); $more_assoc_names = select_names($val); if($more_assoc_names){ ARG HELP IM NOT SMART ENOUGH }
} // end while(!$stop)
} // end foreach($assoc_names as $key => $val)
-- http://www.radinks.com/upload Drag and Drop File Uploader.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php