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-base
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
tak 31. avgust 2001. 10:04
> To: Robert Vukovic; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] SQL problem
>
>
> Hi,
> Are there any error messages?
> Just a guess - may be this will work
>
> Select $tbl_virtual.thumb1,$tbl_descriptions.short_desc FROM
>
> Table was created with this
>
> CREATE TABLE `descriptions` (
> `id_property` bigint(20) NOT NULL default '0',
> `short_desc` varchar(255) default NULL,
> `long_desc` text,
> KEY `id_property`(`id_property`),
> PRIMARY KEY (`id_property`),
> UNIQUE KEY `id_property_2`(`id_property`)
Table was created with this
CREATE TABLE `descriptions` (
`id_property` bigint(20) NOT NULL default '0',
`short_desc` varchar(255) default NULL,
`long_desc` text,
KEY `id_property`(`id_property`),
PRIMARY KEY (`id_property`),
UNIQUE KEY `id_property_2`(`id_property`)
) TYPE=MyISAM COM