469,603 Members | 2,148 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

Tree Structure

So I know you can't outright make a simple tree structure in SQL, but I
could sure use some help figuring out how get around it. I wanted to develop
a simple picture gallery where you put picture in categories, and each
category can have subcatergories, and each subcategory can have
subcategories...and so on. I want to try and keep the processing minimal
since this is just a simple picture gallery. Anyone have any suggestions?
Jul 19 '05 #1
6 6463
The following link contains an excellent article titled explaining the
two majow methods to of dealing with heirarchical data in databases:
http://www.sitepoint.com/article/1105

I had the same problem and found this very useful. Hope it gets you on
the right track.
Jul 19 '05 #2
The following link contains an excellent article titled explaining the
two majow methods to of dealing with heirarchical data in databases:
http://www.sitepoint.com/article/1105

I had the same problem and found this very useful. Hope it gets you on
the right track.
Jul 19 '05 #3
The following link contains an excellent article titled explaining the
two majow methods to of dealing with heirarchical data in databases:
http://www.sitepoint.com/article/1105

I had the same problem and found this very useful. Hope it gets you on
the right track.
Jul 19 '05 #4
Ray
"Amit Varia" <sp**@amitvaria.com> wrote in message news:<bu**********@geraldo.cc.utexas.edu>...
So I know you can't outright make a simple tree structure in SQL, but I
could sure use some help figuring out how get around it. I wanted to develop
a simple picture gallery where you put picture in categories, and each
category can have subcatergories, and each subcategory can have
subcategories...and so on. I want to try and keep the processing minimal
since this is just a simple picture gallery. Anyone have any suggestions?


I have a genealogy database in MySQL, with 40k records of
inter-related people. So a tree is definitely do-able. Basically
just have a field that references the primary key of another record.
Jul 19 '05 #5
Ray
"Amit Varia" <sp**@amitvaria.com> wrote in message news:<bu**********@geraldo.cc.utexas.edu>...
So I know you can't outright make a simple tree structure in SQL, but I
could sure use some help figuring out how get around it. I wanted to develop
a simple picture gallery where you put picture in categories, and each
category can have subcatergories, and each subcategory can have
subcategories...and so on. I want to try and keep the processing minimal
since this is just a simple picture gallery. Anyone have any suggestions?


I have a genealogy database in MySQL, with 40k records of
inter-related people. So a tree is definitely do-able. Basically
just have a field that references the primary key of another record.
Jul 19 '05 #6
Ray
"Amit Varia" <sp**@amitvaria.com> wrote in message news:<bu**********@geraldo.cc.utexas.edu>...
So I know you can't outright make a simple tree structure in SQL, but I
could sure use some help figuring out how get around it. I wanted to develop
a simple picture gallery where you put picture in categories, and each
category can have subcatergories, and each subcategory can have
subcategories...and so on. I want to try and keep the processing minimal
since this is just a simple picture gallery. Anyone have any suggestions?


I have a genealogy database in MySQL, with 40k records of
inter-related people. So a tree is definitely do-able. Basically
just have a field that references the primary key of another record.
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Steve Johnson | last post: by
1 post views Thread by googleo | last post: by
1 post views Thread by Srihari | last post: by
4 posts views Thread by Stephan Tobies | last post: by
3 posts views Thread by _DS | last post: by
1 post views Thread by David Hirschfield | last post: by
5 posts views Thread by hankypan1 | last post: by
8 posts views Thread by =?ISO-8859-1?Q?m=E9choui?= | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.