Ben Liu wrote:
<SOLVED>, almost. I read the article suggested by K.Bear and found the
recommended solution to be a bit more complicated than I wanted to
implement. I then found another way to do this using the existing
"Adjacency List Model" through a recursive function. So basically, you
query the database for the post_id of the very first post in the
discussion. You then call a function that displays that post, searches
for all children of that post and then calls itself recursively on
each of the children it discovers. This works great for spitting out
the posts in the proper order. Now I'm trying to figure out how to
make sure the indenting looks right in the browser.
- Ben
Wouldn't that involve a separate SQL query for every post? Avoid that at
all costs. That's insanely slow and wasteful. Recursive functions have
no business using SQL queries. I'd suggest you start looking for a more
sane method of doing this.
Regards, Adam.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
