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

????

can you explain specific the answer about my questions ?
sory !