what i want is a list of every topic, ordered by the latest post in that topicso....\[code\]select (table.topics) some type of join, select (table.posts where post_topic = topic_id) order/group by table.posts.post_date\[/code\]i want to see each topic once and only have the latest post accociated with each.the topic columns should have no effect on the sort. just the fact that they are all there and sorted by the lats post.please help me my forum is sorted by latest topic created right now!
