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

Member Avatar

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?

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

Member Avatar

diafol

sorry for bad eng

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

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.