issues with last post

[namtax]

hi, i am setting up the topic list for my forum, and i want to show when the last post was. I have a table for topics, and a table for responses. These tables are linked together.

On my topic list page I have a query

SELECT * FROM topics
LEFT OUTER JOIN topic_messages
ON topics.id_topics=topic_messages.id_topics_messages

However when i output the query it is repeating the topics in relation to how many many messages there have been for that specific top...
The only way I have found to display the topics once is to remove the join in the query and have
SELECT * FROM topics

But this means I can no longer draw the "last post" info from the messages table...

Any ideas of how to get round this???Cheers

[Dan_Bracuk · Accepted solution]

read the cfml reference manual. Specifically, read about the cfoutput tag and it's group attribute. If you don't have a manual, google <cfoutput>

[namtax]

that it......much appreciated for help

cheers