RE: [PHP-DB] TREE in a database
True, but isn't this script a bit database intensive? You shouldn't have to hit the database so many times, or doesn't this query as much as I think? But thank you for the article, It is perfect for my problem too. olinux --- Robert Vukovic <[EMAIL PROTECTED]> wrote: > Thanks, that is exactly what I needed and it doesn't > look so > complicated. > > > -Original Message- > > From: John Lim [mailto:[EMAIL PROTECTED]] > > Sent: 31. oktobar 2001. 16:44 > > To: [EMAIL PROTECTED] > > Subject: Re: [PHP-DB] TREE in a database > > > > > > Actually relational databases are set-based. The > answer to > > your tree structures question is that it is > possible. It is > > quite complicated though, so have a look at this > phphoo > > tutorial: > > > > http://www.webreference.com/perl/xhoo/php1/ > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] TREE in a database
Thanks, that is exactly what I needed and it doesn't look so complicated. > -Original Message- > From: John Lim [mailto:[EMAIL PROTECTED]] > Sent: 31. oktobar 2001. 16:44 > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] TREE in a database > > > Actually relational databases are set-based. The answer to > your tree structures question is that it is possible. It is > quite complicated though, so have a look at this phphoo > tutorial: > > http://www.webreference.com/perl/xhoo/php1/ > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] TREE in a database
Actually relational databases are set-based. The answer to your tree structures question is that it is possible. It is quite complicated though, so have a look at this phphoo tutorial: http://www.webreference.com/perl/xhoo/php1/ Rick Emery <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Relational databases really are tree structures. However, whereas a tree > parent node has pointers to children or sibling nodes; in a relational > database, the nodes "point up" to the parent node. The nodes might also > maintain a field to identify sibling nodes. > > -Original Message- > From: Robert Vukovic [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 29, 2001 2:03 PM > To: 'Php-DB' > Subject: [PHP-DB] TREE in a database > > > Is there an easy way to implement tree structure in a database. > Something like file systems do for files. > > Hints, links, anything. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] TREE in a database
The OASIS project for ad-server uses hierchical system for the sections stored in Mysql. the simplest structure is a row with 3 fields(node_id - autoincrement, parent_id int, data - sometype). the root has parent_id NULL or 0(because autoincrements usually starts from 1, but this is subject to change by user). I think that this makes clear how to implement the tree. Have fun. -- Andrey Hristov Web Developer Icygen Corporation BUILDING SOLUTIONS http://www.icygen.com On Monday 29 October 2001 03:02 pm, you wrote: > Is there an easy way to implement tree structure in a database. > Something like file systems do for files. > > Hints, links, anything. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] TREE in a database
Relational databases really are tree structures. However, whereas a tree parent node has pointers to children or sibling nodes; in a relational database, the nodes "point up" to the parent node. The nodes might also maintain a field to identify sibling nodes. -Original Message- From: Robert Vukovic [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 2:03 PM To: 'Php-DB' Subject: [PHP-DB] TREE in a database Is there an easy way to implement tree structure in a database. Something like file systems do for files. Hints, links, anything. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]