FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


hierarchical data/nested/mlm table design ???





netpro
How to make mlm/binary script - one member have maximum 2 direct downline.

I have search at google and find for my reference:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
and
http://www.sitepoint.com/article/hierarchical-data-database

Then I make script pursuant to above mentioned my reference.
And the table is like this (5 field):
field name:
id - title - parent - left - right

I have problem about position.
Are there I must add new field 'position' to store member position on left or right.
how to manage that member can only have 2 direct downline ?

and how to get member level depth ?

please explain me about the algorithm hierarchical data ?

Thanks
netpro
Anybody can help me please ??? !!
Mgccl
why would a person even think of making a new data system when you use mysql is perfectly fine..=.=
till now, I only used one flat database... and that database used some compression method and what... make it over 100 times faster than MySQL.... but it only work with a specific data type..,
netpro
????
Sad

can you explain specific the answer about my questions ?
sory !
Related topics
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.