+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Can I use MPTTree with multi trees in one Table ?? (/showthread.php?tid=22411)
Can I use MPTTree with multi trees in one Table ?? - El Forum - 09-08-2009
[eluser]Mahmoud M. Abdel-Fattah[/eluser]
I want to use MPTTree in products table in Web App, so each user will have his/her products tree.
so, There will be a column called user_id ! will this make some confusion to calculation functions ? or it'll be fine ?
Can I use MPTTree with multi trees in one Table ?? - El Forum - 09-23-2009
[eluser]TheFuzzy0ne[/eluser]
I don't think that MPTTree has been designed to work with multiple trees. Technically, each tree should have it's own table. I might be wrong here, but I'm sure that you can't manipulate multiple trees within the same table. A way to get around this, might be to give each user a top node in that tree (just under the root node), however, I'm not sure if this will cause problems if you're tree becomes too big.