Syl X Posted October 24, 2006 Share Posted October 24, 2006 Good Day All !I haven't really had any experience with Trees. And, I've got aproblem that I see can be tackled in either one of two ways - usingTrees or Tables in the DB.Here's the problem: I've got a threaded list, but it can only go twodeep. Here's what it looks like :--> AD 1------> Question 1-----------> Answer 1-----------> Answer 2------> Question 2--> AD 2--> AD 3Essentially, people either ask a question or respond to a question.And, that's as far as it goes. I've implemented it using Threads, andI'm querying the DB with findAllThreaded().I'm looking for some advice from those of you who've worked with thiskind of thing more. Would it be wiser/more efficient/easier toimplement this using a three table model ?1) ADs2) Questions3) AnswersWhen I display them, the appropriate Ads, Questions, and Answers mustbe visually connected.Here is some extra info..... both questions and answers have only 3fields in common with the 15 fields in my ADs table. I've been sittingon the fence on this one.Thoughts anyone ?Thanks all !Syl Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.