>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 8/28/2002, 9:04:27 PM, Pierre-Alain Joye <[EMAIL PROTECTED]> wrote
regarding Re: [PHP-DB] how to display tree struct
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 8/28/2002, 9:04:27 PM, Pierre-Alain Joye <[EMAIL PROTECTED]> wrote
regarding Re: [PHP-DB] how to display tree struct
On Wed, 28 Aug 2002 18:02:09 -0700
"leo g. divinagracia iii" <[EMAIL PROTECTED]> wrote:
> and you have a 90-98% accurate translation. handy site to keep around...
My kind of 'bible' ;-). Seriously think to buy his book :)
pa
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Pierre-Alain Joye wrote:
> Hello,
>
>
> http://membres.lycos.fr/sqlpro/Tree/SQL_tree.htm provides a good way to store trees
>in a DB, docs are in french, nut sql&images are universal.
>
> hth
>
> pa
>
run this URL through the translator at
http://babel.altavista.com
and you have a 90-98%
adapted to your database ... for errors and more information .. let me know
";
}
echo "$text";
}
# Main function, to be called recursively
function Parse_Tree ( $level=0, $parent=0 ) {
$db = mysql_connect("localhost", "root", "password");
Hello,
http://membres.lycos.fr/sqlpro/Tree/SQL_tree.htm provides a good way to store trees in
a DB, docs are in french, nut sql&images are universal.
hth
pa
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
adapted to your database ... for errors and more information .. let me know
";
}
echo "$text";
}
# Main function, to be called recursively
function Parse_Tree ( $level=0, $parent=0 ) {
$db = mysql_connect("localhost", "root", "password");
an example :
my table :
Field,Type,Null,Key,Default,Extra
CATID,int(10) unsigned,,PRI,NULL,auto_increment
PARENT,int(10) unsigned,,,0,
TEXT,varchar(40)
TYPE,set('FILE','POST','FOLDER'),YES,,NULL,
code ( using ADODB ) :
function PrintNode ( $level , $text) { # função para impri