Help with designing threaded discussion group
From: Jakobo <jakob37_at_ofir.dk>
Date: 22 Dec 2005 15:49:08 -0800
Message-ID: <1135295348.710083.88630_at_g14g2000cwa.googlegroups.com>
Im trying to design a threaded discussion group in an intranet application. Basicly i want to design the database and the subsequent sql statements so that i put a minimum of workload on the server/client handling the application, avoiding looping through large arrays. I want to be able to get all the root posts of the group, and unfold one of these root posts showing all the underlaying posts in a hierarchical tree structure. Have so far planned for following properties of a table design (holding a single discussion group); field0 - post id (auto number), thread - (post id of root), answer (post id of parent) together with other fields reg. the post itself (author, date, subject, mess. text).
Can anybody please help with idears about how I should design the table and/or construct sql statements so that i can retrieve data from a record set and put them in a hierarchical structure without having to loop through large arrays. Im working in a windows invironment, using IIS, mysql, vbscript serverside, jscript clientside. regards
Jakob Outzen Received on Fri Dec 23 2005 - 00:49:08 CET
Date: 22 Dec 2005 15:49:08 -0800
Message-ID: <1135295348.710083.88630_at_g14g2000cwa.googlegroups.com>
Im trying to design a threaded discussion group in an intranet application. Basicly i want to design the database and the subsequent sql statements so that i put a minimum of workload on the server/client handling the application, avoiding looping through large arrays. I want to be able to get all the root posts of the group, and unfold one of these root posts showing all the underlaying posts in a hierarchical tree structure. Have so far planned for following properties of a table design (holding a single discussion group); field0 - post id (auto number), thread - (post id of root), answer (post id of parent) together with other fields reg. the post itself (author, date, subject, mess. text).
Can anybody please help with idears about how I should design the table and/or construct sql statements so that i can retrieve data from a record set and put them in a hierarchical structure without having to loop through large arrays. Im working in a windows invironment, using IIS, mysql, vbscript serverside, jscript clientside. regards
Jakob Outzen Received on Fri Dec 23 2005 - 00:49:08 CET