table records to tree view CI

[rohitrohitrohit]

hi ,

i have two table i want result in tree view.how to do it.
if i have n level question and answer then what is db design for it

thnx for any help

[diafol]

??
what do you mean n level? Are they based around pk/fkcardid?

---7K post!---

So is this like a card name for the node and then sets of questions and answers?

[rohitrohitrohit]

thnx for reply
suppose a person post a question so multiple answer can be submitted or question can be a asked.

on every answer and question there parent child decided.

i need db design and guide for acciving this..

sorry for bad eng

tnx

[diafol]

sorry for bad eng

Yeah well, not my first language either, but I don't understand your last comment.

[rohitrohitrohit]

Yeah well, not my first language either, but I don't understand your last comment.

tops-tech.com/demo/DecisionTree1/editTree.php

i want to achive this but it is in xml i wnt it with db

[pritaeas]

Not quite sure if this is what you mean, but if the answer decides the next question, you can add a second parent id (next question id) to the child table.