Re: creating a threaded message system--sorting messages
| From: | Richard Lynch | Date: | Fri, 30 Jun 2006 20:01:58 +0000 |
| Subject: | Re: creating a threaded message system--sorting messages | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-239020@lists.php.net to get a copy of this message | ||
On Thu, June 29, 2006 9:11 am, Ben Liu wrote:
> I'm trying to present the messages to the users in
> threaded order rather than flat. I'm having a lot of trouble figuring
> out how to sort the posts so they appear in the correct threaded
> order. I don't think I can do this purely with a SQL query.
You can.
The thing to do is to store the "pre-order traversal" as a "threaded
tree" in your database.
If you Google for those terms along with SQL, you should find some
articles that will help you tame this beast.
--
Like Music?
http://l-i-e.com/artists.htm