2 Replies Latest reply on Dec 30, 2006 7:47 AM by namtax

    issues with last post

    namtax Level 1
      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