How do you convert a parent-child (adjacency) table to a nested set using PHP and MySQL?
I’ve spent the last few hours trying to find the solution to this question online. I’ve found plenty of examples on how to convert from nested set to adjacency… but few that go the other way around. The examples I have found either don’t work or use MySQL procedures. Unfortunately, I can’t use procedures for this project. I need a pure PHP solution.