Re: [PHP] hierarchies

2009-03-27 Thread Shawn McKenzie
PJ wrote: > Not quite, but interesting option. This would be fine on my local > intranet, if needed; but I don't think this would be allowed on a > virtual hosted site. > > Actually, my problem is to use a header.php (for example) in pages in > the webroot directory or any directory within (or und

Re: [PHP] hierarchies

2009-03-27 Thread Jason Pruim
PJ wrote: Jason Pruim wrote: PJ wrote: I do have a bit of a problem which has not been clearly explained in the suggestions to my previous posts and that is the question of hierarchies. I have not yet understood how to include a file anywhere in a directory tree and have it point to the

Re: [PHP] hierarchies

2009-03-27 Thread PJ
Jason Pruim wrote: > > > PJ wrote: >> I do have a bit of a problem which has not been clearly explained in >> the suggestions to my previous posts and that is the question of >> hierarchies. I have not yet understood how to include a file anywhere in >> a directory tree and have it point to the rig

Re: [PHP] hierarchies

2009-03-27 Thread Jason Pruim
PJ wrote: I do have a bit of a problem which has not been clearly explained in the suggestions to my previous posts and that is the question of hierarchies. I have not yet understood how to include a file anywhere in a directory tree and have it point to the right file which may be in the top d

[PHP] hierarchies

2009-03-27 Thread PJ
I do have a bit of a problem which has not been clearly explained in the suggestions to my previous posts and that is the question of hierarchies. I have not yet understood how to include a file anywhere in a directory tree and have it point to the right file which may be in the top directory or, m

Re: [PHP] Hierarchies and MySQL with PHP

2004-06-28 Thread Mattias Thorslund
Warren Vail wrote: I did one once where the key to the table was a string, and the string contained 1 to n Node Numbers separated by a separator character. "1" "1.1" "1.1.1" "1.2" select data from table where node between (1 and 2) resulted in an entire limb of the tree being retrieved. Limitation

Re: [PHP] Hierarchies and MySQL with PHP

2004-06-27 Thread Mattias Thorslund
Marek Kilimajer wrote: This should be of your interest: http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/4047/ Indeed! The "flat table model" is simple, efficient and - I think - sufficient. Thanks! I also found this article which explains the "fourth" method not reall

RE: [PHP] Hierarchies and MySQL with PHP

2004-06-27 Thread Warren Vail
he number of leading zeros for each node. Not pretty, but it works well for small trees. Warren Vail -Original Message- From: Mattias Thorslund [mailto:[EMAIL PROTECTED] Sent: Sunday, June 27, 2004 9:59 AM To: PHP General Mail List Subject: [PHP] Hierarchies and MySQL with PHP Hi, I wonde

Re: [PHP] Hierarchies and MySQL with PHP

2004-06-27 Thread Marek Kilimajer
This should be of your interest: http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/4047/ Mattias Thorslund wrote --- napĂ­sal:: Hi, I wonder what you think are the best (or "least worst") strategies to store and retrieve hierarchial data (such as a "threaded" discussion or a

[PHP] Hierarchies and MySQL with PHP

2004-06-27 Thread Mattias Thorslund
Hi, I wonder what you think are the best (or "least worst") strategies to store and retrieve hierarchial data (such as a "threaded" discussion or a multi-level menu tree) in MySQL using PHP? I have been using table structures where each row contains a parent reference, such as: Table Example:

Re: [PHP] Hierarchies

2001-11-28 Thread MindHunter
ot; > (level=$level)(counter=$cnt)"; >ShowTree($element[$cnt]['cid'],$level); > } > } > > ShowTree(0,0); > > > -Original Message- > > From: MindHunter [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, November 28, 2001 9:27 AM

RE: [PHP] Hierarchies

2001-11-28 Thread Dimitris Kossikidis
=$level)(counter=$cnt)"; ShowTree($element[$cnt]['cid'],$level); } } ShowTree(0,0); > -Original Message- > From: MindHunter [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 28, 2001 9:27 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Hierarchies > > &

[PHP] Hierarchies

2001-11-27 Thread MindHunter
Hi, I need to display hierarchies (hierarchical structures). I have a MYSQL table with data like this: Node,Parent A, B,A C,A D,B E,B F,D G,A It can go down to 10 levels. I do not want display one level and then click to display the next, I want to see the entire tree at once, say like this: