pageId title parentId nodeIndex
1 home 0 0
2 child 1 of home 1 0
3 child 2 of home 1 1
4 child 1 of child 1 2 0
5 child 2 of child 1 2 1
where nodeindex is the manual sort order.
I need the output from the database to be shown in the correct parent-child order. the output cannot be a varchar since it will be larger than 8000chars.
child 1 of home
child 1 of child 1
child 2 of child 2
child 2 of home
Dear Sir/Madam, This job can be done quick and easilly with best quality and professionalism. I have all required knowledges and experience to achieve success of this project. Please see my profile. Pelase check Daha Fazla
4 freelancers are bidding on average $30 for this job
I understand you problem with this tree. I can help you. Please look at the PMB.