Manny Ramirez
|
Posted: 08/06/2002, 9:26 PM |
|
I need to know how to create a tree that is 2 or 3 levels deep using the
TREE for categories.
I have a category that requires
TOP, 1st level, 2nd level
How can I do this, using Codecharge 2.0.5?
|
|
|
Andrés Fernando Gómez T.
|
Posted: 08/10/2002, 1:36 PM |
|
look the yellow pages example ... in your DB, table, categories, create
another subcategory :
CREATE TABLE categories (
category_id int(11) NOT NULL auto_increment,
category_desc varchar(50) default NULL,
sub_category_id int(11) default NULL,
PRIMARY KEY (category_id)
) TYPE=MyISAM;
....
INSERT INTO categories VALUES (1, 'Software', 0);
INSERT INTO categories VALUES (2, 'Hardware', 0);
....
INSERT INTO categories VALUES (15, 'CodeCharge', 1);
INSERT INTO categories VALUES (16, 'SUN SPARC', 2);
|
|
|
|