|
|
Posted by Jim Michaels on 11/21/75 11:37
CREATE TABLE `dbo`.`categories` (
`cat_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`category` VARCHAR(100) NOT NULL DEFAULT '',
PRIMARY KEY(`cat_id`)
);
CREATE TABLE `dbo`.`subcategories` (
`sub_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`cat_id` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`subcat_id` INTEGER UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY(`sub_id`)
);
I think you'll need a recursive function to traverse the tree. if you need
it, I can write one.
"Beshoo" <basheermoro@gmail.com> wrote in message
news:1136923318.502352.55300@z14g2000cwz.googlegroups.com...
> Heeeeey:
> I have a problem in making photo gallery so that I can add unlimeied
> cattegories,sub categories ??????
> I Tooke a look at "4 IMAGE scrtipt" the use ( id and P_id ) idea
> BUT, I cant get it ,so plz if you havr any wey out TEL ME
>
> THAAAAAANX in advance
>
Navigation:
[Reply to this message]
|