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

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 right file

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

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 under)

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. Limitations were

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

RE: [PHP] Hierarchies and MySQL with PHP

2004-06-27 Thread Warren Vail
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. Limitations were the size of the

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 really

RE: [PHP] Hierarchies

2001-11-28 Thread Dimitris Kossikidis
You can do it only in few lines of code with a recursive function... You can display full tree structure with unlimited levels. Mysql Table : cid int, parent int, Name varchar Cid parent varchar 1 0 A 2 1 C 3 0 B 4 1 D 5 2 E 6