RE: [PHP-DB] trees in MySQL

2002-12-19 Thread Cal Evans
http://froogle.google.com/froogle?q=%22SQL+for+Smarties%22&btnG=Froogle+Sear ch Chaps 28 & 29. (ok, I had to read both but it sounds like you already understand the concepts.) The end of chap 29 he gives a simple example for maintaining what you are talking about. I used it to write a dynamic men

RE: [PHP-DB] trees in MySQL

2002-12-19 Thread José Moreira
ara: [EMAIL PROTECTED]; Php-Db (Correio electrónico) Assunto: Re: [PHP-DB] trees in MySQL If you don't know how many nodes you're going to have and the amount of branches under each node, then that's the only way to do it. However, if you can define those numbers, you can use somet

Re: [PHP-DB] trees in MySQL

2002-12-19 Thread Ignatius Reilly
The difficulty you are being confronting could be alleviated by using an XML data model (meaning non relational). Of course, I don't know about your requirements, but it could be a direction worth investigating. I use the php_xslt.dll (sablotron) extension, which I find works quite pleasantly.

Re: [PHP-DB] trees in MySQL

2002-12-19 Thread 1LT John W. Holmes
If you don't know how many nodes you're going to have and the amount of branches under each node, then that's the only way to do it. However, if you can define those numbers, you can use something like the following. A manager would have 50 numbers, for example. So, rather than counting through th

RE: [PHP-DB] trees in MySQL

2002-12-19 Thread Hutchins, Richard
Jose, In addition to any advice you may receive from your post today, check out the PHP archives. I distinctly remember a discussion related to these models maybe a month back that may be of interest to you. Don't remember if it dealt with your specific concerns, but I'm pretty sure it dealt with