Hello,
I need help with a design of MySQL table. This is for a MLM script that has one matrix table that describes the actual matrix itself. I now need to create a table that would have the userid's of every user in different matrices and their relationship to each other.
The problem I am encountering is that a depth of 10 levels could be 1000's of users in the matrix....
So, with that being said, what would be the best design for this?
Thanks for any help!