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

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

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

2001-11-28 Thread MindHunter
I've tried to convert this function to ODBC. Anyone that can help? Tx MH Dimitris Kossikidis <[EMAIL PROTECTED]> wrote in message 000801c177eb$adea5500$0300a8c0@mits">news:000801c177eb$adea5500$0300a8c0@mits... > You can do it only in few lines of code with a recursive function... You > can dis

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