Re: Listing threads by newest posts?

[Kyle Menigoz]

All the tables mentioned are part of a forum system that I am creating.

The first table, 'forum_threads' has an index of 'thread_id', while every entry in 'forum_posts' is related to an entry in the threads table. I currently have the threads listed by newest thread first (column name: 'date'), but I am wanting to order the threads by the newest post.

Ex. Currently listed as:
thread 1 - post 1 02/23 05:55
thread 1 - post 2 02/24 12:12

thread 2 - post 3 02/23 19:21



The way I want would be like this:

thread 1 - post 1 02/23 05:55
thread 2 - post 3 02/23 19:21



Edited 1 time(s). Last edit at 03/03/2009 06:58AM by Kyle Menigoz.